No wonder Britain's about to leave the EU. According to this thread, a significant part of the nation are small minded, slightly stupid xenophobes.
Amsterdam is a beautiful city. It's genuinely stunning. It has architecture, history, culture, amazing food and great nightlife. It has great infrastructure, tons of international visitors and nice weather. It's a startup and innovation hub ffs. Of course it has more than prostitutes. People visit for the same reasons they visit Barcelona or Paris. It's also under an hour by train to The Hague or other amazing cities in the Netherlands. It's well connected to other parts of W Europe. Also, everyone speaks English!
In 2012, Amsterdam was ranked the second best city in which to live by the Economist Intelligence Unit (EIU)
pages.eiu.com/rs/eiu2/images/EIU_BestCities.pdf
If your DH is a dickhead, then he'll be a dickhead wherever he goes. And frankly, he won't be missed. I think a lot of European countries are sick of British tourists going to other places and assuming that other countries are some sort of sex and drinking playground for them to be twats in. They aren't. People who live and work in Amsterdam are (on average) better educated, wealthier and healthier than people in the UK.
People in Amsterdam should be avoiding us, not the other way round