Well the idea isn't that bad, but people seem to think if one or two forbidden things are possible then all of a sudden everything that was forbidden is possible. You'll end up with Amsterdam.
Also problematic is the fact that in a lot of countries everything is outlawed so they might go looking for hard drugs where soft drugs are being sold. I've seen enough tourists seen thrown(1) out of a coffeeshop for asking any kind of hard drugs. What they don't find in coffeeshops they do find with street dealers.
I'm far from a puritan - I thoroughly enjoy my beer (and rum, and slivovice ...etc) - but let's be honest, the addictive properties of alcohol together with the societal, social and physical damage that it can cause either match or exceed substances which are otherwise treated as "drugs".
This is not to say I think alcohol should be banned or more strongly controlled, but rather that we should really rethink how we harshly we view things like cannabis
On an ecological level tourism is a bad thing yes. Now maybe it'd be good for the economy or whatever but I don't think making $ should be the priority. Plus Luxembourg isn't really in need of money.
Do you have a definition of tourism that doesn't imply travelling ?
The only point of comparison I have is amsterdam and people are definitely flying/road tripping there for short "drug vacations" (I genuinely think everyone I know has been there at least once for that purpose), which in my book is not so good for the environment and a more than debatable reason to fly/drive hundreds of kms.