Blues Brothers is pretty good, as is Dirty Dancing. More recent films with, in my opinion, great soundtracks are Moulin Rouge and Chicago - great for singing along to in the car!
Pulp Fiction and Trainspotting are my favorites. The Statler Brother's "Flowers on the Wall" track on the former holds many a good (if rather dubious) memories for me!