Amsterdam is still clean and quiet compared to other major cities. To be honest, I suspect the main factor to be the red light district. Just visit the Reeperbahn in Hamburg. I'd argue it's much worse and they don't offer legal weed. To be clear, I'm not arguing for or against prostitution, but against prostitution as a tourist attraction.
If prostitution was legal, or decriminalized (I believe sex workers and advocates prefer decriminalization over legalization), everywhere, it wouldn't be much of a tourist attraction.