We can refer to Lewin's classification of 1924, very simple and very basic but sufficient. Because drugs can make us euphoric, excited, intoxicated, sleepy or hallucinated.
Euphoriants: the reference in this area is the film "Once upon a time in America" in which we see a Robert De Niro who has forgotten everything he has done until now and who, under the effect of opium, becomes completely euphoric.
Stimulants: these are cocaine, enphetamines, caffeine; they contribute to give more energy, to create strong feelings and to maximize the pleasure. Paradoxically, they don't bring excitement but only take what was already there. They therefore lead the consumer to overconsumption and to the practice of a scorched earth policy, the last stage possibly being a loss of capacity to be able to be active.
Intoxicants: alcohol is initially a stimulant then destroys the body's functions and becomes a sedative.
Sedatives: All sleeping pills can lead to death. Benzodiazepines are prescribed to treat anxiety, fears; they have a sedative function but alter perceptions, mood as well as olfactory, touch and visual sensations and can impair coherence of thought
Hallucinogens: opium is a euphoric then becomes a sedative. Morphine is also used as a painkiller.
Let us remember that a product can have several effects and create different sensations during the history that it has with its consumer or rather that the consumer has with him.