1. Shiina Ringo - No one writes songs as complex and just down right thought provoking as she does. Period.
2. Utada Hikaru - She writes some of the most interesting lyrics I've seen from any artist
3. Hyde (L'arc~en~Ciel) - He writes some of the best lyrics I've ever seen from a male. His bands older works (pre 2004) are his best work in my humble opinion. He's even won awards for his lyrics.
4. There's too many others to list at the moment...
I can't think of any 'terrible' lyricist at the top of my head personally. But I will say this, whomever wrote Namie Amuro's "Want Me, Want Me" needs to be thrown into the dark abyss never to be found again. That song is utter trash.
__________________

|