I don't think he's taking heroin, I think it's a drug that mellows him out and gets him stoned 'stoned hotel room' rather than high. I don't think he dies of an overdose, I think he shots himself, because the line is 'Spoon to the lighter to the lighter to the gun' and the bit about 'a pool of sun' is hi lying on the floor in a pool of blood.
I don't think he's taking heroin, I think it's a drug that mellows him out and gets him stoned 'stoned hotel room' rather than high. I don't think he dies of an overdose, I think he shots himself, because the line is 'Spoon to the lighter to the lighter to the gun' and the bit about 'a pool of sun' is hi lying on the floor in a pool of blood.