Of recreational drugs it seems maybe the least harmful. It rarely results in serious harms and effects seem impermanent except maybe heavy use while young.

Hyperemisis syndrome seems unpleasant, but seems related to high potency extracts.

Smoking anything is bad for you.

Humans like drugs so having safer ones is good.

Humans will use drugs so these questions are kinda pointless. Whether it is good or bad it's been around for thousands of years