I have to admit I'm somewhat puzzled over the animosity towards the SB128. Between here and the office, I have 3 SB128s (each based on an ES1370 chip, not the 1371 or the newer CLxxxx), a CMI8738/C3DX, a TB Santa Cruz (CS4630) and a CS4236. The CMI8738/C3DX and the CS4236 are on-board chipsets found on my IWill KK266-R and an older IBM Intellistation, respectively. The others are PCI cards.
For MP3 listening, I really don't think you're going to tell the difference, assuming the drivers are up to snuff. For instance, in Linux the ALSA drivers for the CMI8738 suck so you should stick with the OSS drivers for now. I will also note that there currently seems to be some "issues" between XMMS and the OSS CMI8738 driver that causes mp3s to skip annoyingly. Other Linux-based mp3 players (mpg123, mpg321, etc) do not exhibit this problem though. I don't have an WinXP box so I can't comment on the driver quality over there but Win2K seems fine with SB128 and the TB SC.
I've listened to each of these through AKG 501 headphones at one time or another and really can't tell the difference. The SB128 can reach higher volumes than the others but sound quality is basically the same. Even the ISA-based CS4236 (it's on-board but connected via the ISA bus) sounds fine for playback. I've also listened to the CMI8738, one of the SB128s and the TB SC piped through a Denon 3200 going through Definitive Technologies ProTower 400s and BP2Xs and they sound virtually the same.
Recording is another matter. The CS4236 has nowhere near the dynamic range that the others have. For instance, if you record line-in while playing King's X "The Train" (one of my personal benchmarks since it's mixed so badly), the CS4236 can just barely pick up the vocals. The others including the SB128 have no problems with this song.
I don't play many games so I can't make many comments here. This means I don't know how well EAX or whatever the soundfield-of-the-day performs.
Keep in mind, that there were several versions of the SB128. The first version came out shortly after Creative bought Ensoniq and was very similar to the Ensoniq AudioPCI which was and still is a decent card. Later versions performed worse as Creative started cutting corners.
For some fairly in-depth sound quality analysis of various cards past and present, take a look at
pcavtech.com
So, in summary, it comes down to what you're looking to use it for and the quality of the drivers.