Well, most of the differences are that in the Boxed/Club editions there are more drivers. There are the official nvidia and ATI drivers integrated into the distribution.
Almost any program that you could want for linux is available through urpmi and rpmdrake(the Graphical front end to urpmi) if you've set up your repositories correctly.
You can set up your repositories by visiting
http://easyurpmi.zarb.org and following the steps(don't worry it really is easy).
Unfortunately, Linux probably won't be a direct windows replacement for you if you're not willing to take the time to learn how to configure things like video streaming(I haven't bothered to set that up so I can't help you there). A lot of things that would be set up "automatically" in windows might take a little more configuration in Mandriva or any other Linux distribution.