Again, it completely depends.
First, what
speakers will you be fueling. Having a super sound card is pointless if you have just average speakers or even a cheap set of 5.1 or 7.1 speakers. There's nearly no point going all out on a soundcard unless you have really high quality speakers to put them too.
Games - which audio settings? What added settings? EAX? Just direct 3d? Dolby Digital Live? Creative has great gaming cards on their highest end. Performance is the main thing in gaming soundcards; you want to unload most of the work from your system and keep it on the card. After that, it's all about how many simultaneous sounds the thing can playback. Higher is better of course. Again, the big creative latest cards are good here.
Music - Performance means nothing, you just want it to sound as good as possible. Crisp, clear, and plenty of outputs. Asus cards and Auzentech cards are fantastic here. You don't need creative at all; they have a reputation for having a bit less quality on this part.
Movies - Output is king here. And by that, I mean dolby digital or DTS. There's no point in caring about the card unless you have a good sound setup that can manage high quality DTS or DD. And for this, the X-Plosion is simply boss (because it does all of it, hardware, for the cheapest, with the higher quality).
Overall, you sound more like an average user. So you could go with either a latest gen Creative, or you could get the Auzentech Prelude 7.1. Overall, the Prelude is the one I would recommend. For the cost and it's overall output, I'd go with it due to quality.
This is merely my opinion though.
Very best,