Visiting connecticut is a great idea if you like food, wine, or beer.
The Connecticut Wine Trail (don't know what jungweissbier was talking about, I think the wines are pretty darn good)
hiking/camping/nature/foliage - plenty of it, all over the state
J. Timothys Tavern, Sliders, The Black rock - these are a few places for awesome wings
The Cottage - great restaurant
Thomas Hooker Brewery - smal brewery, great beer, I've been on the bottling line there, was good fun
There are tons of places to go to have a good time in CT, depends on what you want do there.