Apologies to @Tiggerlion, shamelessly picking up on your ‘Songs of a Generation’ thread in which you mention that some classics can actually end up being a millstone around the artist’s neck.
This made me immediately think of Babybird, known to just about everyone solely for ‘Your Gorgeous’, a song I’ve never liked but which was clearly a classic for many at the time. A mate talked me into seeing them live quite a while ago now and I went along somewhat apprehensively as this song was all I know about them at the time. When they came to sing it, frontman Stephen Jones said: ‘Here’s the song that ruined my career’. Given the content of the rest of the gig, I couldn’t have agreed more as the rest of set was tremendous and he/they deserve a wider audience, yet will be remembered for that one song.
Here’s one of many finer moments from Babybird. Any other bands/artists you feel have suffered a similar fate (apologies if this has been done before on here).