I thought it was interesting that Nassau County(i.e. Long Island) is included since I agree that for what it is(just another suburb) the price of houses on Long Island is outrageously expensive. In many areas the homes approach $300,000, which is only about $50,000 less than a home in Queens. When you factor in that real estate taxes run $7,000+ on L.I. versus about $2,500 in Queens, and you don't need to own a car in Queens, it's actually cheaper to live here, and there are more opportunities for jobs, culture, etc. To me Long Island looks no different than upstate New York, where you can buy a house for $50,000 and you don't have to deal with traffic on the L.I.E.
When looking at areas to live it is important to factor in the total cost of living. Consider that the real estate taxes for an average home in N.Y.C. are fairly low, and you can take the subway to work. Both these things probably save you over $10,000 annually, which is enough to cover another $125,000 in mortgage at today's interest rates. Or put another way, the cost of housing here isn't excessive. Thanks to competition, you can also buy nearly anything here cheaper than anyplace else in the country if you hunt around, so that's another factor to consider. And then there are the intangibles, such as the city's cultural environment and relative freedom from natural disasters. And anywhere I live has to have seasons, although I'd prefer a place without summers. The only main disadvantages of N.Y.C. in my opinion are the hot, humid summers, and the noise and pollution from cars and airplanes.