Welcome! I have no idea what there is to see in Connecticut, but I advise any diver who lives close to water to invest in equipment for at least monthly dives (preferably biweekly) to maintain/improve skills.
I started diving when I lived in CT (Hartford).
Dive sites, not much I drove to RI or northern MA for most of my diving.