Besides obvious examples like Hour Man and Popeye, I can think of two heroes who used intoxicants to gain superpowers.
In the Wild Card books [edited and co-created by George RR Martin] Captain Trips uses various concoctions to become a bunch of different heroes, including one female, making him one of the few transgender metahumans.
IntoxiKate [Heroes Anonymous series] is a telepathic alcoholic. She gets lit, and then can share her trip with anyone else in the area.
[nerd alert]
Besides obvious examples like Hour Man and Popeye, I can think of two heroes who used intoxicants to gain superpowers.
In the Wild Card books [edited and co-created by George RR Martin] Captain Trips uses various concoctions to become a bunch of different heroes, including one female, making him one of the few transgender metahumans.
IntoxiKate [Heroes Anonymous series] is a telepathic alcoholic. She gets lit, and then can share her trip with anyone else in the area.