There is a D.C. super villain named Snowflame who gains super powers from snorting cocaine
Snow Flame is able to increase his strength and cover himself in white fire when he ingests cocaine. He also claimed that his strength increased the more he fought. It’s unknown how he gained these powers.
Snow Flame’s first and only appearance was against the New Guardians when they attempted to stop his drug cartel. Snow Flame easily bested the team in their first battle against him after he ordered his men to simply shoot the heroes. The heroes survived and faced off against Snow Flame once more. This time they did much better and after a chaotic battle Snow Flame was tossed into a shed, by his followers, which promptly exploded. He was assumed dead and has never been seen again.