Most of the drugs (except for some of the psychoactive drugs,) will make your Sim wake up with a hangover the following day. Most times hangovers can be cured by doing more drugs. Or wait it out, of course.

The hangovers gives your Sim uncomfortable or negative moodlets.

Pro tip: Smoking Cannabis makes the uncomfortable and stressed out moodlets disappear faster.