We have a great life in a suburban area of a large village/small town in Connecticut.
The weather is actually great, we've got a great community, large houses, the children can play on the streets and bike down the roads, which they couldn't do when were in the UK. We are actually quite close to New York, which is great because we can go and have fun easily, but have a relaxed life here. We have a basketball hoop in our front garden and DD1 and 2 play with their friends outside there to practice shooting or whatever they call it. It's green, and lovely. It's not as vibrant as London for instance, or as fast paced, but its perfect for a family due to being close to a big city etc;
Also have to say, Stockholm. We only moved to the UK to follow jobs (first Belfast, then St Albans) but we moved from Kiruna to Stockholm. I love Stockholm. We lived in an area called Liljeholmen, it was next to a giant park with a giant lake, a playground area, slopes to toboggan on. We lived in flats, but they were very large, well insulated and were amazingly good quality compared to the UK for instance with a giant communal garden thing which was great, with a playground, and we knew everyone in the block, there was a train station, and tram stop close by, it was quiet and friendly and not too snowy (although I say that as we moved from Kiruna, which is way up North, in fact I think roughly 150km past the Arctic Circle!) There was Gamla Stan nearby, and it was easy to get around. In fact, Gamla Stan (the Old City) was great- Christmas market, resteraunts, beautiful old shops, a great place. There were also loads of great museums to visit, and if you speak English as a first language (I don't, I'm Swedish, but DH does) then it's also easy to get around as so many people understand it.
I'd reccommend Connecticut or Stockholm. However, some parts of the Stockholm Archipelago (islands around Stockholm, from fifteen mins from Stockholm to a few hours, the best ones to live on I'd say are around thirty minutes from Stockholm, so not as close, but easy to get there too). A very nice community, beautiful landscape, loads of outdoor sports, especially kayaking, esay to get to the city, sometimes wonderful beaches, and from my experience a lot of people living there are very welcoming and lovely.