Mine’s is This Woman’s Work by Kate Bush. I’m a huge fan and went to see the film She’s Having A Baby specifically because it was written for the soundtrack. It blew me away, I played it to death for years, then one day I just couldn’t stand it. I think it was a combination of overplaying it and its cliched overuse on adverts and documentaries trying to make you feel sad.
Another example is Come On Eileen. I loved Dexys, wore the stupid dungarees to see them live and danced to COE at every function and disco. Now I’d race across a room to switch it off. Again probably through being overplayed and reminding me of being 17 and in shitty relationships and friendship groups and a job I hated to boot 🤣.