I live in Santa Barbara where it has arguably the best weather in the country. But I miss Upstate NY weather. And just like the OP, I grow weary of the jokes.
If the economic opportunities were equal, I would pick Upstate NY over 80% to 90% of the country.