When someone talks about drug use, they usually mean recreational drugs like meth, coke, heroine, psychedelics, opioids, etc. Some people also mean weed, which is kinda dumb. And yeah, there is definitely recreational drugs that can be beneficial to some extent. And of course they're not all the same. For instance many popular psychedelics don't have the same destructive consequences of, say, opioids. But most recreational drugs, while they can be used in moderation in a way that is not destructive and doesn't end in nasty addiction (well, except for some, which almost always lead to nasty things), they very, very often aren't used like that, and it doesn't just have to do with the user, it has to do with the substance itself, as well as social factors. But the substance plays a big role too.

So, if I am to make it more specific, recreational drugs, barring some popular psychedelics, are very frequently very destructive. Not all in the same way, but generally they are. Some psychedelics are too, sometimes in different ways.