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!”