Many of us live up here... I've lived in Claremont, NH my whole life. Yeah, the weather can suck from time to time, but you adapt. The worst part about New England's weather is it can change in an instant. For example, it was 53 degree 2 days ago, and today it was snowing and in the 30's... Very mild temps for January as it's usually in the teens and below 0 at night. This has been a really mild winter for us with very little snow.
The one major benefit of living up here? Saabs... and lots of them. Just in a 20 mile radius there are probably about 10 Saablink members here. Put it up to a 50 mile radius and the number more than quadruples.
The other things we have... Lots of covered bridges, skiing/riding, tons of boating and fishing, hunting (if you're into that), beautiful scenery, foliage, mountains, amazing breweries (harpoon, rock art, switchback, magic hat, etc...), Canada, Beautiful old homes from the 1700's, no sales tax (for NH), seat belt's and motorcycle helmets optional (NH), The ocean isn't too far away, etc... It's definitely a different place to live. It's also very expensive up here compared to almost anywhere else in the country, and you don't make nearly enough to compensate for the higher cost of living.
That said, the summers are great up here!