GiantFan666 mentioned my favorite -- the original Blues Brothes soundtrack. An incredibly tight band, fun songs, and guest appearances by Ray Charles and Aretha Franklin. Pretty solid stuff.
Here's a very obscure one, but one of the more enjoyable movie soundtracks in my CD collection: Tin Cup (kevin costner golf movie) has an EXCELLENT soundtrack. Check it out some time -- here's an Amazon link