Not the original topic (drugs), but could have been written for Prism: He knows you know (but he's got problems), by Marillion #prismsongs
Including one of the best lines ever: "Singing psychedelic praises to the depths of a china bowl."