Paris, there's a whole syndrome named after it. Apparently (oftentimes Asian) people will travel there and be so disappointed they get genuinely depressed.

Don't get me wrong, it's a cool place to visit, but it's a big city like any other.