It honestly comes down to you. As others have already mentioned, onboard has definitely come a long way, but it's still by no means the same as having a dedicated sound card. However, many people are 100% happy with their modern (and even old school) onboard sound and that's awesome, I'm jealous actually; it would save me a lot of money!
Personally I have not met anyone that I have convinced to install a sound card to not notice a difference right away in the quality of audio. Although of course you need a quality pair of speakers/headphones, if you just have some run of the mill desktop speakers there's only so much they can do.
As far as game performance increase, I would say with most modern games, and with the power of modern multicore processors; it's going to be negligible as with games such as BFBC2 or BF3 the sound is actually processed on one of the cpu cores, even if you have a dedicated card, and then it's fed through the card.
Before I got my ProFire I had an Audigy 2 which out did all of my onboard audio processors from when I bought it back in 2002 until about 2010. My brother also runs an X-fi gamer, although I would have to say you may want to avoid Creative because of their drivers, they are by far the worst I've ever seen and it doesn't seem like they have ever really improved. Although I've heard nothing but good things about Asus and their Xonar line.
And remember, if audio is really important to you don't let anyone tell you spending a lot on quality equipment is a 'waste of money'. Nothing is a waste of money if you get enjoyment/use out of it. Nothing is more important to me than audio, and to me even these BX8a's don't cut it, once I get some money I'll be getting a nice set of Focals
Good luck!
Edit: Just an update, in my comparison between my Audigy 2 and onboard audio processors, I was not using any special audio effects or 'enhancements', especially not 'crystalizer' or the 3D speaker effect, just a pure audio comparison.