I'd say anything with AC'97 basic sound would not be good, and anything with Soundstorm would be best (for onboard) with the C-Media chips probably also not being bad.
SoundStorm uses AC'97 bus and codecs.
Integrated AC'97 audio is built right in the chipset and accesses the CPU via low latency multi-threaded interconnect which, depending on the chipset, has anywhere from 2 to more than 10 times the bandwidth of the ancient 133MB/s PCI bus that was all the rage circa 1994.
Unfortunately, integrated audio is still lacking in high fidelity recording capabilities, such as true 24-bit/96KHz resolutions, the bare minimum for high fidelity recording (24-bit/192KHz preferred). Even so, the best integrated sound engines and codecs shipping today are certainly no worse, and sometimes better, than many sound cards purchased to replace "crappy" integrated audio.
Your best bet would be to visit any support forums at the manufacturer's website of the sound equipment you want to use, if one is available, and ask actual users which motherboards and/or chipsets are proven to work well. If the manufacturer doesn't have a forum, then a PC audio forum instead of a general PC forum.