David Bowie may count. "Life on Mars" and "Ashes to Ashes" speak in metaphors and can be taken in so many different ways. "Life on Mars", in one lyric, can be making a reference to either Lenin or Lennon.
Then there is Queen and their body of work. "Bohemian Rhapsody" is overflowing with metaphors, as well as most their early work (prior to 1981).
One of the artists that I use with my students to find figurative language is Pink Floyd. Specifically the song "Time" uses a variety of metaphors and extended metaphors to make a point. These metaphors include the comparison of life to a race, and the passage of time being indicated by a ticking clock. Many Pink Floyd songs contain several instances of figurative language.