In my 1998 E39 I use the standard 75W90 which is also what Redline recommends. From the product description, however, you'd think 75W90NS would be the same or better.
75W90 is easier to find, and would work fine, IMO.
Although it doesn't apply to any BMW I know of, GL-5 lubes including 75W90 and 75W90NS should be avoided due to soft metal compatibility and other reasons. The LSD adds in the standard 75W90 will not play well with the synchros. If you need 75W90 weight in a manual, use MT90.
FWIW, they recommend D4ATF in my E39 ZF 5-speed for easiest shifting. I'm using MTL for a slightly higher viscosity (long-term protection and closer match to factory fluid) as well as to use a fluid actually designed for synchros. In the winter it's a touch notchy before warmed up, in the summer I can't feel any downside.
Craig.