I don't really understand why certain lyricists get under people's skin, for example Bob Dylan. Dylan was the soundtrack to my growing up. His words meant something to me, usually something completely different from what he meant when he wrote them. The same applies to the lyrics of John Lennon, Jimi Hendrix, David Bowie and a host of others over the years.
Can I think of the worst lyrics ever? Not really because all lyrics go with music and some really silly lyrics, like umpah, umpah, stick it up your jumper, make the song, in my opinion. Conversely some strong lyrics go with melodies I don't like.
Interesting discussion though.