All the places listed above are a lot of fun. I also like Keene airport in New Hampshire as it’s a nice airport with long runways and not a lot of traffic. There is a resteraunt right adjacent to the field there that you can walk to from one of the parking areas. For big trips you could also fly the VfR corridor down the Hudson and NYC. It’s easily done in an afternoon from Ct.
Inside Connecticut you can fly to Windham airport and walk up over the hill to the aero diner or around the corner to a Dunkin if you just want a coffee.
If you want some more challenging places to practice landing there is Goodspeed airport where the final leg of the pattern brings you right over the top of the old swing bridge and the other end of the runway ends in the water. It’s not as bad as it sounds but it’s a good idea to have an instructor with you the first time unless you are good at short field landings. I think they do seaplane ratings out of Goodspoed now as well. The airport is also walking distance to the Goodspeed Opera house which has many great Broadway style shows for not a lot of money and can be fun on a Sunday afternoon.
Marlborough also has a very nice privately owned but public use grass strip. If you are looking to rent, Chester has a piper cub and instructor that will take you into Marlborough and Goodspeed as they are all relatively close to each other. Westerly Rhode Island can also be fun to fly into and hang out for a while. There are (or were) a few t6’s that fly regularly as well as a banner tow business you can watch how they pickuo and drop banners during the summer and on weekends.
If you have money to burn then Ellington airport has a helicopter school. There is also a skydiving operation out of there and a flight school. It’s not as busy of an airport as it sounds but keep your head on a swivel when in the pattern because the helicopters fly a right pattern and the skydivers have been known to drift into the downwind leg of the left hand pattern. I want to say that there may also be a place for ice cream by Danielson airport but it’s been a long time since I have been there.