I think recreational drug use is demonstrably good for society and part of all succesful civilizations. Take caffeine, sugar, alcohol and tobacco as the primary examples. All potent drugs and all taken habitually and en masse by all the most successful societies in the world.
More like all the most successful societies value personal freedoms. Personal freedoms are clearly good for society and a big one of those is recreational drug use of which tobacco use is quite common.
Having a government which restricts personal freedoms too much for the sake of "societal good" may work in the short term or for specific issues but is clearly a negative in the long and broad terms. See the "west" of today for evidence of personal freedom combined with not-overly-restrictive-legislation being the most successful method of handling these things.
