I lived next door to you in Bloomfield for 21 years, then spent a couple of years bouncing around the Mansfield/Willimantic area while at UConn.
The Housy is a good possibility for July for me if I can find a place to park my family for a couple of days.
On floating the CT river, If timed right that could be an interesting striper, small mouth & shad trip. I remember a ramp in the shadow of the Bissel Bridge that could be a good take out point.
I have to get an ok from the boss before thinking about either trip though.