To be honest sambo it depends what you want. Historically you could say Amsterdam has it all. Rotterdam was flattened in the war so a lot of the centre is quite modern. But also has some clubs and nights (don't ask me what but Rotterdam has a big clubing scene by all account, lol). The crack pills and etc comes with the territory you walk about in and these days that is also reducing with heavy policing and cameras around all the back alleys etc. What I always found in Rotterdam was that if you were going from one place to another it was always miles away. Amsterdam has different areas you can hang in that offer different things as well.
As for the rest of Holland, Leiden and Gronginen are quite big University towns and have all that come with that, Utrecht reminds me of a mini Amsterdam but is also nice, and Den Haag gives me the willies, lol, I spent a night at Her Majesties mercy there. But Den Haag is full of kakkers - posh Dutchies and the rich expat set.
Antwerpen in Belgium has a cracking reputation for clubing, and is a really nice city and not far away. I wouldn't mind going on a binge down there sometime.
So yeh, it all depends on what tickles your pleasure buds.