Sahib: Interesting indeed. I suppose the song you have linked to is in English, but, between the dialect and most recent singers' habit of drowning themselves out with their instruments, I can't understand a word. Is it written out somewhere?

However, from your comment I infer that the songs you mention are from places where the stuff is illegal, so that praising it has subversive effect, and not from places where it is or was part of the dominant culture, as in Jamaica or parts of the Middle East. Did the Jamaican cane cutters have songs about how useful it was in getting thru a day's work?

An amusing song in which *coffee* is treated as subversive (I suppose with some satirical intent) is "Eyes of Night Owls" by Bob Kanefsky.