DS's favorite (and one that I can actually stomach) is Putumayo Kids Presents New Orleans Playground. We also have the Caribbean Playground one but I prefer the NOLA one. We have a CD of songs with DS's name in every song and it SUCKS so bad that when we listened to it on a road trip I wanted to slit my wrists. Needless to say, we haven't listened to it since. We got them all (including the personalized one) from Learning Express.
Re: Kids music...
LOVE They Might Be Giants (any of their albums)
LOVE Barenaked Ladies Snacktime CD
My kids love Laurie Berkner, and she puts them to sleep
I second the They Might Be Giants CD.
I know they have some CD's of traditional kids songs on the endcaps at ToysRUs.
My kids love everything WIGGLES.
Raffi is also great for the old favorites.