I got Born to Be Wild by Steppenwolf in my playlist, and often when that song comes into my mix, I'll skip it. usually has a habit response to how overplayed it is, but also because it's often used ironically, which just kind of ruins it.
But when I do actually listen to it, it's a fantastic song, start to finish. All in all, it's a shame.
What great songs have been ruined for you by their success?