Great question.... God Moving Over the Face of the Waters from Heat...
As soon as this question came up, I thought of this one. Agreed. (Took me a while to find this piece of music too, I might add...)
Others I thought of...
Where is my Mind at the closing sequence/end credits of Fight Club
. Okay, I admit I was a Pixies fan before seeing the film, but it's now forever linked in my mind to the buildings collapsing. Really, the music in that movie fit the style of the film perfectly, in my opinion.
Closer(Precurser) at the opening sequences of Seven
Another film where the music really did a great job of setting the mood throughout the film to me was the really strange banjo(?) music in Ravenous
. But I realize that you guys were asking for something more specific.
On the whole, I'm drawing a blank all of a sudden, but for laughs, I'll offer up the following:
Damn, It Feels Good to be a Gangster from Office Space
EDIT: As a side note- I agree with you guys about bringing back the "Homework" segment of the show. I thought that was a great feature.
Would also like to add, perhaps as a counterpoint, that I really despise when a film only has enough budget to get only one song, and then proceed to use it multiple times during the film. I've seen this happen a few times with lower budget films and it annoys me every single time. (Granted, they usually aren't very good movies to begin with, but still...)