I know what you mean about that conflict between good music and lyrics which can be cringeworthy. One of my favourite Irish tunes which I've been learning to play is called The Limerick Rake. I heard it on an album by The Pogues but even though I don't sing, the song lyrics make me cringe and then I can't enjoy playing the tune. It's a first-person song about a womaniser.