Well for me there are a number of these. Here are the most heinous.
Dancing in the Dark: I can no longer enjoy this song for itself because as a fan of SNL, everytime I hear it the image of Steve Martin and Gilda Radner pop into my head dancing at silent movie speed.
Layla: Goodfellas and the scene with the gangster on the hook in the freezer.
CSI: I know Pete had the right to lease his property, but it cheapened his work.