Everyone uses different grades of oil. Sometimes a car is just "happier" with a particular thickness of oil. You'll also get a different opinion of oil from every gearhead you ask...
Diesel and Gasoline grades are interchangeable. Check the rating on the bottle. Current API ratings are "SN" for gas and "CF" for diesels. Motorcycles need a different mix. The anti-wear additives can make wet clutches slip.
The BMW is spec'ed in the owner's manual with a sliding temperature chart. So OEM will vary through the year. Per BMW tradition, they also tend to use slightly thicker oils than most other manufacturers. That's been changing recently though. The thinner oils can save a few MPG, as can synthetics. BMW has adopted both.
I've heard a lot of guys using diesel oil in their gas cars...Delvac is very popular. Never used it myself though.
Here's mine:
I use synthetics, typically the 5L jugs of Mobil1 from Wally World. They're better IMHO because you don't need to change them as often, they often give a slight increase in fuel mileage, and they keep the motor & intake cleaner even on an oily little beast like the M42.