Yes, it's good for the government to not be tyrannical, but I'd argue that when the majority of people increasingly and collectively want things that are net negatives for society like recreational drug use, it's a red flag that society is in decline.
You seem to be conflating a distaste for demonstratively failed policy, like as prohibition, with an appetite for what you are calling "recreational drug use".