I can't find a continuous video that gives you the real full effect, but one of my favorite uses of music was in Grosse Pointe Blank when then did the transition from the "Mirror in the Bathroom" song during the fight scene and started playing "99 Luftballoons" while they were cleaning up the body.
Here's the setup:
...and the exact moment I'm talking about is the beginning of this clip: