I'm all over the map on this one.
I love Neil Peart, but it's more of a love affair with Rush as a whole versus just the lyrics. The lyrics by themselves are sometimes cringe worthy, but in the context of Rush they work beautifully.
In terms of lyrics, I like Jackson Browne, Gordon Lightfoot, John Prine, James Taylor and Bob Dylan. Honestly, I don't listen to these guys all that often because I'm not as big a fan of their music as I am of their lyrics. I also like Don Henley's lyrics (far more than Frey's lyrics), but I've heard these songs so much I'm burned out.
I like a lot of Pat Benatar's lyrics and I love listening to Neil Geraldo play guitar. Melissa Etheridge does the whole "longing for something better" lyric delivery better than most. Shawn Colvin's "the world is truly fucked up for us artists" lyric bent is good within that context.
Tom Petty's lyrics match the music so well; generally, straight forward and unambiguous. It's hard to pull this off without sounding "whiny".
Personally, I don't care for writing lyrics. I'm ALWAYS recording new music and I'm always lacking lyrics. If anyone has lyrics looking for a song, let me know!!