I'm not sure what the drug debate of your country is like, so please correct me if my assumptions are incorrect.
In my experience, the drug debate lacks nuance, it's mostly the hardcore fans or the drugs-will-kill-you crowd that we see, while more level-headed voices are drowned out.
There's also a problem with facts. Research on a lot of drugs have been prohibited for a long time, making this a relatively new field of study.
With more studies, we're going to see confirmation of certain theories and rejection of others, making our knowledge more fact based and less opinionated.
My highly personal opinion is that it is a mistake to talk about drugs as one thing. There are tons of different drugs, and each one should be discussed by itself, not as a part of drugs. I also firmly believe that we are individuals and we all respond different to different chemicals. Saying that a chemical will have this effect on everyone is a mistake. I do however believe that a good setting, a sensible dose and someone watching over you, can drastically reduce any negative effects.
With that said, the "high" is not for everyone and that is okay.