For people who like big dense cities, you have NYC and SF. That's it. SF has all the 99% of the good tech jobs and great weather.

However, as soon as my employer opens up an office in Berlin, I'm out of the US. Even denser, even cooler and way better public transit.