I contacted BMW on this subject a couple of years ago as at the time I had an M140 and the LL04 certification/specification had just been dropped from all Castrol Edge products except the “M” one.
This is what they said:
"Thanks for your latest email about your engine oil concern, on receipt of your email I presented it to our technical team to assist me with. And I’m pleased to advise they’ve provided the following details, please see below -
The Castrol Edge engine oil is an approved oil, but not a recommended oil.
This is due to the introduction of Diesel particulate filters and Otto Particulate filters in our vehicles. The Castrol Edge oil is not a low ash oil (under 0.5%m – Castrol Edge is at 0.8), and that’s why it has changed. The high ash oils may clog the filters over time.
BMW are recommending the low ash oils now.
When checked by our Technical Department, the specification of your BMW 1 Series (VIN WBA1S920305Hxxxxx) shows as not having an OPF installed, so you can continue to use Castrol Edge oil if you wish.
I hope this information provides appropriate clarity on this concern for you."
So it boiled down to BMW moving the goal posts on what LL04 was required to achieve. The 04 part of the spec realtes to a standard established in 2004, long before anyone thought of Diesel or Petrol Particulate Filters.
All oils are a compromise as they have different jobs to do. The perfect lubricant for the engine would destroy catalytic converters, clog exhaust filters, and likely reduce fuel economy. My NC (like my M140) doesn’t have a particulate filter, but does have a catalyst, so either of the oils mentioned above were fine.
It is easy to overthink all this. If you go on an oil manufacturers website and use their oil finder tool for your specific car, you will get thier recommendation. Just choose your favourite brand and do that.
Personally I am running Petronas in all our cars as it is a hugely respected global brand, their online selector tool works well, it comes in 5L tubs, and Halfords often have it discounted which I then get another 10% off with the club discount scheme. Therefore it usually costs about £27 a tub.