That's not NIMBYism or hypocrisy. It's just liberalism. You don't like something, but you think it should be legal. That is exactly what liberalism is about. You do not have to like everything and in fact, if you only want to allow things that you like, you're not liberal. It's precisely the acknowledgement of other people's right to do things that you do not like that defines liberalism. But at the same time you have the right to not associate with people who do these things. You give them their freedom and they give you yours. There is nothing hypocritical about that.

Also some of the things you describe are just addiction and coping, euphemizing it.