Here are some suggestions for an adult tour. If you're taking kids I'd stay at N. Conway, Winnepesaukee, and the beaches in Maine otherwise, here's the tour:
Mystic,CT - Foxwoods is about 15 miles away and is a lovely 5 star resort casino. They Also have fine spa services.
Drive up 95 and stay at ocean house in Rhode Island. It's a reclaimed old hotel on the beach. Once in a life time experience. While there, take the Newport Mansion tour. Extraordinary.
Continue up 95 stay in Boston - see the Boston thread - sights to see covered there. Link.
http://www.dcurbanmom.com/jforum/posts/list/472125.page
Continue up 95 sTay at Portdmouth NH. Very quaint, walkable. Fine dining, shopping. Shop the Kittery outlets across the bay.
OR North Conway is a young family destination. It's better in winter with skiing. Otherwise there's a couple of water park amusements and hiking and boating if that's what you like. Otherwise, I would stay at Lake Winnepesaukee instead.
Continue up to Bar Harbor, ME and spend a couple of nights there or any of the Maine beaches on the way.