I highly doubt Waters used smack or was a junkie. I don't know Roger personally, and hard drug habits tend to be a very private thing so I dunno for sure. The lyrics Roger sang in Comfortably Numb always reminded me of a doctor administering a shot of morphine if anything. Seeing the live performance from The Wall shows drives that home even more imo. Roger sang the song wearing a friggin doctors coat!