I have always stuck with creative for a sound card, the X-Fi series (IMO) is good and reasonably priced.
Onboard is getting better but its no substitute for a dedicated card, though DX10+ renders the difference moot since it takes out the hardware acceleration for sound processing. OpenAL doesn't do that though and many games are using it as standard now over DX10.
The high end X-Fi's or any cards with memory on them aren't of much use to the average user, games don't take advantage of it, etc.