Heh, I have a nice collection of sound cards I've built up.
All Ensoniq cards (including Soundscapes and AudioPCI)
SB16, AWE32, AWE64, SB32, Live, A2ZS (had a SBPRO until a friend gave it away!!)
Roland SCD-15 daughtercard
Diamond MS MX300 (Vortex2)
Turtle Beach A3DXStream (Vortex1)
Philips Seismic Edge (Tbird128)
I am sort of a 'puter multimedia freak and have been since the early '90s, so I've used lots and lots of cards. The MX300 has awful audio quality honestly, other than the Vortex 2's 3D audio capability of course. It must have awful analog circuitry/DACs. The Turtle Beach card as excellent quality however. Creative cards pre-Live! were noisy POS's usually. You better like Rice Crispies cuz those cards definitely snap, crackle, and pop.
For DOS games, nothing really beats that SCD-15. The Soundscape Elite board though is very very competitive and can sound better at times. AWE cards are god awful unless you can load a soundfont on them in Windows or use a daughtercard.
Audigy 2 definitely has some 3D audio capability, but it's nothing mind-blowing I'd say. It works well though. But it's not a card that stands out from what's come before in 3D audio. That may be because of a lack of proper developer support though. It has fantastic audio quality though. Crystal clear response with excellent separation and zero noise. Better than Live! for certain.