I personally am a fan of people like John Lennon, who say such things as, "Yellow mellow custard, dripping from a dead dogs eye". Or Bob Dylan saying "Jewels and binoculars hang from the head of the mule". Such lyrics to me evoke pictures in my mind and create controversy and speculation and interest.
Usually such musicians don't look at the world in such a literal sense and use strange sounds and words to evoke weird pictures and ideas.
I also like song's like Metallica's "One" that tell a story of a man horribly injured by war. Even the music sounds thought provoking, with the machine gun like intervals of stacatto electric guitar.
Songs like Jimmi Hendrix's machine gun are amazing. When a man has the ability to sum up the 60's in raw form not just with lyrics, but mostly with an electric guitar sound that sounds as tormented as the time itself, thats not music, it's an exorcism. Lyrics should exorcise very internal feelings that the listener didn't even know they had.