There is a D.C. super villain named Snowflame who gains super powers from snorting cocaine

Actual character quote.

“Cocaine is my God — and I am the human instrument of its will!”