I thought it was great when our company paid for us to have a weekend away (was about 30 of us or so). I love old beautiful cities and Amsterdam doesn't fail at all. The red light district is a bit of an eye opener for someone who comes from the sticks, but let's not kid ourselves, unless you have been under a rock for years then you can see a lot worse from a quick Google...
What was most interesting was the way the red light district blended in with the rest of the city. So for example there is one area where this is this nice old building, possibly a museum or church, and opposite you have Burger king or McDonalds. No worries. Then next to it is an adult video shop with the front window showing un-censored scenes. Weird. And then walking through a normal market (away from red light district) you see what most people would consider fairly hardcore images on postcards (the one I remember is female genitalia dressed up as a Mexican, including, ahem, a ciggie...). Gotta love it...
And as long as you don't mind hookers coming up to you in the street and people wanting you to watch their sex shows or sleep with their hooker etc (normally in red light area) then you will probably love it. It's your typical lovely old European city if you don't count the much larger than normal red light district. And the other main difference is the red light district is not considered that seedy compared to other cities. You can walk around and feel perfectly normal going to a bar there or whatever compared to feeling like a massive perv criminal type anywhere else (heh, not that I've been to any others, but when in Amsterdam you have to check it out to tell people what it's like).
Come to think of it I think most of Europe is a lot more relaxed about sex and the like than us. When in Germany I was in a standard blockbusters type video shop that had the English films upstairs. Right next to the hardcore sex area. With adverts on the walls outside (ie. in the English bit) showing uncensored hardcore images. And the condomi shops were fun. And in Spain they had all sorts of stuff for sale in normal shops. Then again Blackpool can get a bit racey... ish...
Cheers
I am 99% probably lying in bed right now... so don't blame me for crappy typing
Current fave quote : "She was like a candle in the wind.... unreliable...."