Creative X-fi (and the rest of their products) is all about hype and bullshit. They've been doing the same crap for years, trying to sell $150 sound cards when a $5 chipset/$20 card is just as good.
It's not going to make a lossy compressed MP3 sound better than the CD source material. You can't do that. Upsampling a 16bit/44.1kHz source to 24bit/96kHz doesn't get you anything; you can't recreate the information that was lost (however small) when they sampled the audio at 16bit/44.1kHz.
As far as I know, the Mac Pro uses Intel's audio chipset:
Intel High Definition Audio
I think you'll be happy with it, but if you need more/better input/output options, look at M-audio's internal and external sound cards.