Drugs in fantasy novels often play a role in character development which in turn affects the plot. For instance, a character who becomes addicted to a certain magical substance may start to make bad decisions, which can lead to their downfall or redemption. Their struggle with the addiction can be a central part of the story arc. Also, the existence of these drugs can attract different factions in the story world. Some may want to control the production and distribution of these drugs for power or profit, and this can create complex power dynamics and political intrigue that shape the overall plot.
Drugs in fantasy novels can be a major plot device. For example, if a character is poisoned (a form of 'drug' in a sense), it can set off a search for an antidote, driving the plot forward. If a hero drinks a magic potion that gives him superhuman strength, it can change the course of a battle and thus the overall plot.
Some drugs can also be used to create conflict. Let's say a group discovers a powerful elixir that can grant great power. Different characters may have different ideas about how to use it or who should get it. This can lead to internal strife within the group and also attract the attention of other forces in the story. The drugs can also be used to introduce mystery. A strange potion that causes people to forget their memories can create a lot of intrigue as characters try to figure out what happened and how to reverse it. All these elements greatly influence the plot.