It’s definitely a crazy world and a shame that drugs are such an integral part of the music business. I’m glad that you (and a lot of other people) managed to not fall into the trap.
I think it was Charlie Musselwhite who had a similar experience to yours. I read an interview where he said he tried heroin once and it was so good that he knew that there would be a heavy price to pay for using it, so he never did it again.