i only boulder so i don't know many specifics - but Chatfield Hollow in Killingworth has some great sport climbing i've heard. a bit more trad than sport but there are certainly some lines, here is the mtp: https://www.mountainproject.com/area/106051782/chatfield-hollow-main-wall
looks to be 14 routes ranging from 5.11a to 5.13b
here's a link to the guidebook https://smile.amazon.com/Rock-Climbing-Connecticut-State/dp/1493009907?sa-no-redirect=1