We all have those tunes that just get under our skin, but what happens when it’s one you came up with in the first place? Kevin E G Perry and Roisin O’Connor take a look at artists who’ve come to loathe their own creations