"Puff the Magic Dragon" is probably the most obvious. A druggie song disguised as a cutsie fairy tale. I liked the Creedence song "Who'll stop the rain" and recently learned that the word "rain" really meant "war". The Stone's "You can't always get what you want" is loaded with interesting lines such as "she was going to meet her connection, at her feet was a bleeding man".