"the overall societal cost is high"
Just like every other drug. Everyone wants to legalise marijuana, ostensibly for the tax money (but not really), and yet it has far greater social costs than tax will recover. Even the states that legalise it (and consequently becoming tourist destinations) are not actually benefiting from it even though the "Las Vegas effect" means that they should disproportionately benefit from it.