I think the most 'Emperor's New Clothes' to me, would be Ontario, Canada. The much vaunted niceness and politeness of Canadians was sadly lacking! I heard them talk about it, really didn't see any much of it. It was cold, grey, and soulless. But then again, we went there during an incredibly harsh winter/spring, and were mainly in the 'burbs. I did love the Niagara falls though, and the aquarium.
I can't really talk about NZ from the point of view of a tourist - other than to agree it is very expensive, and that if you go rural, it can feel like you've possibly strayed into a Gothic Horror film. Or a spaghetti western. I do stand by our friendliness though, and our food. If you go expecting a Lord of the Rings fantasy or theme park, you are definitely going to be disappointed.
I loved LA, especially the beach, and people were very friendly. San Fran', I found depressing.
Paris - have always had a great time there, and people have been so friendly, and forgiving of our lack of French. Ditto, Rome. And Madrid.
Loved Byron Bay and Sydney, once again, the people were so friendly, there was a real buzz to it, and the food was great.