I didn't critisize the lyrics because they were about drugs, I don't have any problem with Weiland singing about drugs, I just thought the lyrics were extremely bland and corny.
I think stating that the song or lyrics are about drugs means you simply didn't interpret them correctly.
Taking an analytical approach to the lyrics in the clip allows us to see that they aren't about drugs at all. This is very much a love song. The lyrics are about his love and devotion to his former wife and how he underestimated the enormity of his love. The drugs are simply a peripheral and secondary character in this specific composition. She is the drug and the main focus of the song not the actual drugs. The title "Between the Lines" is a pun used to illustrate this. She was his real infatuation and between the lines of coke he wasn't able to fully discern that. He had failed to see between those lines literally! In my opinion, he is proclaiming this now, and of course he would be remiss if he were to make this song about drugs. He would merely be committing the same mistake once more. Instead, the focus has now changed to her instead of any substance. She was the actual substance he loved most.
The line “you always were my favorite drug" is stated in past tense, almost as a revelation or realization. I think when we are able to interpret the remainder of the lyrics we will be able to see that this is a fully fledged love song in which Scott is looking back and realizing things almost regretfully, and perchance apologetically. The drugs which deluded his vision are secondary and pale in comparison to the story he is telling between the two of them. This could be wrong of course; but I believe these are the emotions Scott is evoking. Hence use of the word "love” in successive lines in order to emphasize his point. I think it is sad that people assume because it is Scott that the requisite meaning is simply drug use.