I really like the score to 'The Ninth Gate' and the Philip Glass 'Mishima' soundtrack as well. I like films to have their own score, keeps musicians in work and has led to some superb music that adds something to the images on screen. The Godfather, Much of Sergio Leone, John Williams, The Japanese guy who works with Takeshi Kitano but whose name escapes me and others are all worth a mention. Agree with Howard Shore doing a great job with the LOTR score.
In terms of those films that plunder our musical history to sell the movie and its soundtrack cd I really liked Grosse Pointe Blank, Pulp Fiction, GoodFellas but how much of that is simply liking the movies I'm not sure. I'd say Scorscese marries the images to the film with slightly more skill but Tarantino seems to be having a lot more fun,