Whatever you use make sure that it is at least the same viscosity as the OEM fluid.
If someone tells you that you should use XYZ fluid because it is 5/10/15 or whatever weight - walk away, they do not know what they are talking about.
Viscosity is measured in Centistokes and has bugger all to do with the weight - as an easily understood comparision, cream is much, much more viscous than milk, yet it is lighter and floats on top of milk.
Also, if you have the BMW red dampers in the bottom of your forks do not use Belray of any peruasion - their secret special ingedient "seal swell" will destroy the red damper quicker than you can say "oh bugger I wish I hadn't done that".
No without lecturing you on the viscosity of various fork fluids (you can find any number of websites to do that!) I'll tell you that Castrol Fork5 is as near as dammit to the BMW OEM fluid - so to is Dexron II/III (not Dexron II/III compatible) auto trans fluid.
But unless you live in a country with billard table roads and you are 75lbs wrining wet, that fluid (and Castrol 5) is too light.
I weigh a classified amount (my wife reads this board) but let's say I admit to being North of 125kg. I use a 50/50 mix of Castrol Fork 5 and Fork 10.
Occasionally you will see bottles of Castrol fork 7.5 - do not be tempted as the mix of 5 and 10 is in fact slightly more viscous than 7.5 - go figure.