It’s amazing how often the artist doesn’t like the big hit. Sometimes from the get.
Radiohead and “Creep”, also some to mind, but I certainly don’t blame them, since they have so many songs better than that one.
And possibly the most famous one is Pinball Wizard. I’ve never heard Townsend outright hate it, but famously he apologized for it when they first recorded it and he’s regularly said he doesn’t think it’s very good.