I can't believe nobody mentioned Until the End of the World... all Wenders movies have great soundtracks.
Trainspotting was OK, but I loved The Acid House soundtrack.
Of course there's the Blade Runner soundtrack and lots of others that I can't think of right now. Buena Vista Social Club, of course, but this is more of an album supported by a movie, than the other way round, isn't it?