Goodfellas
Dazed and Confused
The Big Chill
Five Easy Pieces
Almost Famous (or most any Cameron Crowe film, going all the way back to Fast Times at Ridgemont High)
Note: I don't know if any of these except Five Easy Pieces and Goodfellas qualify as "great films," but the music is certainly central to them all.