AdamWill said: To answer the original question - grab Mandriva and try it. Only you can answer the question for yourself. Of course, if you want my answer, Mandriva's the best, and Ubuntu will probably give you cooties. :)
On codecs - what Powerpack has is the Fluendo codecs (well, not all of them, a subset) which are codecs they've paid the patent holders for a legal license to. This means they're completely legal in the U.S., but it also means they cost money, they're not open source, and they're not freely redistributable. So we can only include them in Powerpack. You wouldn't get these for free in other distros either, we're not hiding stuff from you to make a buck.
With packages from the official repos you should be able to get most stuff playing. The most significant exception is AAC audio. The only way to get that is from PLF, and I should note that the patent-encumbered stuff in PLF is strictly illegal to use in the U.S. (thank the stupid software patent regime).
If you have trouble playing anything in particular, make a post here or in the official forums, and we'll help you out with that particular issue.
could you guys give me a list of common codecs i may want to install ? im burning the iso to a dvd now as we speak.
again what file system should i format too , ext3 ?