Yes, that Roegadyn in the PUG questline uses it through a pipe and becomes ripped with power when you fight him. I don't think it's some type of steroid, per se, but something that you smoke. I could be wrong, though.