The Enter Sandman Effect 

This effect occurs when a song becomes tarnished by the amount of times you hear it, no matter how good the song may be it ends up annoying you. You realise the effect mostly on songs you initially like.

The Enter Sandman Effect occurs most notably (in my opinion) with:
Enter Sandman - Metallica
The Pretender - Foo Fighters

The Enter Sandman Effect by Scott Bevan January 20, 2009

The Enter Sandman Effect 

When a band's most successful song (usually not they're best) becomes they're only known song among non fans.

Joe: "Hey what's your favorite Metallica song?"
Alex: "Oh you know Enter Sandman."
Joe: " Really? I think Fade to Black or Master of Puppents is better."
Alex: "I've never heard those ones."
Joe: "The Enter Sandman Effect." *sigh*

The Enter Sandman Effect by Will Lange February 20, 2015