There are pros and cons. I've lived all over the country, and Connecticut is one of my favorite places by far. I think only California beats it (southern, like San Diego), but it's so crowded & expensive there, meh
So: Connecticut is pretty nice, but it is expensive to live here. Depending on where you live, a lot of stuff shuts down at night. In my town, most businesses close at 9:00pm. The mall closes at 9 or 10pm. There's a lot of cool regional stuff, lots of neat fruit farms to go to (blueberry picking, apple fritters, corn mazes) in the summer & fall, lots of fun festivals (Big E in Mass, Apple Festival, etc.). It's pretty safe if you're not in a big city, but even the big cities aren't bad. Places like Hartford, New Haven, and some parts of East Hartford can be shady. None of them are really bad, except maybe some parts of New Haven. I think IcebergSlim lives down there, so you can ask him what's good in that area if you're going to be there. I'm just outside of Hartford and most of the surrounding cities are nice - Manchester, Glastonbury, West Hartford, Bloomfield, etc. Some are more ritzy than others, so location really depends on your housing budget.
Like others have said, there's a lot of rich areas bordered by some very, very poor areas. Not a ton of inbetween. If you like kind of a rural, spread-out suburbia, it's great. I'm not a city person; I prefer having some green around me. Lots of places to drive to. Lots of good food in New England too. Some nice restaurants and unique places to eat, especially in the surrounding states. It's also very conveniently located. If you're into history or art, there's a ton of places to go. New York, Rhode Island, Massachusetts, etc. are all less than 2 hours away from Hartford. Maine is close, which is really fun if you like seafood. The beaches here are pretty meh, like a bathtub, so if you're into surfing and stuff, don't bother.
The seasons are amazing. 4 seasons, fall is the best. Mild winters - usually only 2 or 3 huge snowstorms. Every other place I've lived has had hurricanes, tornadoes, earthquakes, crazy winters, and so on, but Connecticut is pretty mild. I really like the weather here. It only gets a bit humid in the summer, but it stays moist enough that you don't feel like the heat is sucking you dry. So it's inbetween Texas and Florida in that regard - basically the perfect weather if you want to have four seasons. The people are pretty relaxed here. Not a lot of violence and people are generally civil. A lot of the better-off towns (and there's many) can get on the snooty side, but it's not as bad as some other rich areas I've lived near. People speed like crazy here and use their horns a lot, so be prepared to meet some impatient drivers here (I know that's common everywhere, but moreso here than any place else I've lived).
If you're big on nightlife, it may not really be a good place to move. If you're more family-oriented, then it's pretty sweet. Or if you're like me and prefer to do more things at home - computers, home theater, etc. New York is a stone's throw away, and if you don't want to drive, you can park at Stamford and take the train in really easily. New York is great because it's like going on a mini-vacation whenever you want - tons of great restaurants, shows, sights to see, etc.
Going along with the expensive part I mentioned earlier, housing can be really price. My last crappy apartment in the ghetto was $839 a month, and part of the reason I moved out was because they raised it to $900. The kind of place I didn't let me wife go out after dark alone. If you're looking at an apartment, be VERY careful about what you choose. Pretty much every place I've lived, or looked at, have had major sound problems. The big reason I left my last place was because I could hear my neighbors above & below so well that I could sing along with their music, lol. Even the more expensive places ($1000+ a month) have noise issues. Be sure to talk to people who LIVE in the complex about how they like it, honestly how they like it. Most people are more than happy to share their negative experiences, so it's a good way to get the real scoop on living somewhere.
Cliff's: Nice, but expensive
1. Most places are pricey. People can be a bit snooty, but not totally bad.
2. Be prepared to speed and don't sweat the crazy, impatient drivers who tailgate you at 80mph.
3. Not much on nightlife (in most areas, at least), but lots to see if you're into art, history, and local stuff like fruit farms and festivals. Good food if you search around.
4. Weather is great if you like having 4 seasons. No real negatives other than a couple bad snowstorms a year, so you just chill at home for a day or two instead of driving.
5. Areas I'd avoid: mainly New Haven, most parts of Hartford, and some parts of East Hartford.
Do you have an idea of where you'd be living?