I don't necessarily mean musicals (although the title sequence for Singin' in the Rain is one of the most jubilant moments on film). My picks?
Easy Rider - Jack, Peter and Dennis driving through the great Southwest to the tune of The Band's "The Weight".
On the other end of the spectrum, the bit from Reservoir Dogs featuring "Stuck in the Middle with You" by Steeler's Wheel is quite memorable.