Like others have said, it all depends on both your output ability (speakers/headphones/etc) and your personal ability to tell the difference.
Personally, I don't think I'd ever spend more than $100 on a sound card, unless I was going to use it for dedicated sound sampling and editing. If I was just playing games with it, ****, a 4 year old card would do.