Hey,
Welcome to BITOG.
1. You have to think about warranty. The chances of BMW checking what oil you use are small, but they are there. In case something happens, they might ask for receipts etc. I personally would change oil at BMW during warranty every 10k. In between, I would do my own oil changes every 5K. I personally would never run such oil, BUT warranty is warranty.
2. You have GPF I think. That means you must run something that is low/mid SAPS, preferably approved for LL04. BMWs have a very stringent timing chain test. While Mobil 1 ESP 0W30 is exceptional stuff, and I use it, I would go Mobil 1 ESP 5W30 since it is LL04. That is after warranty. But if you don't care about warranty, that is the oil I would go with if you are going with over the shelf stuff.
3. If you are going with something boutique, check HPL Euro stuff that meets LL04 in 0W30 and 5W30 flavor, or Amsoil 5W30 AEL. Redline has Euro 5W30 that also meets LL04.
With this engine, the VANOS is not using oil pressure, but it is electronically controlled. However, keep in mind that your engine, when cold, runs much, MUCH thicker oil and it survives. Running thicker oil than recommended is never an issue. Running thinner oil is. Now, since it is a mild hybrid, there is an argument that thinner oil is better. But again, that system also works when the oil is thicker during warming up. I personally would stick to 30 grade (not 40) in LL04 flavor. If it doesn't have GPF, then we can talk LL01 options.
Also, that link you provided. Is absolutely useless. When I read this sentence: "Thinner oil flows faster at startup, reduces pumping losses, and allows BMW to run tighter bearing clearances without sacrificing hydrodynamic lubrication," I knew where this is going. 0W is 0W. It does not matter is it 0W12, 20, 30 or 40, it has to meet certain requirements when it comes to dynamic viscosity to be 0W. He confuses cold cranking performance (measured in CCS and MRV) with HTHS. Absolutely useless article.