praised Chris Hogan's Small But Vicious Dog before. One thing about the drug rules therein is that I doubt my players would every risk taking them. I know that not all drugs offer mechanical benefits and that those drugs as Chris has them are probably well suited to the darkness of Warhammer Fantasy, but I wanted drugs that would tempt players.
Here is a single page that combines Chris' rules on addiction with 10 basic drug types. You can name these types for your campaign or you can mix and match them for more complex drugs below. I made a few as examples.
The only thing I wish I could have but don't know how to fit, is how the drug is taken: smoked, drunk, sniffed, etc. The complex drugs below have more room, so you could enter a note there.
Here is the Write file so that you can mold it into something that works for you. Note, more undefined side-effects. Disease will have some too. Maybe a one-page side-effects is the answer.