Check out Narragansett beach in RI. Easy access. It was my go-to surf spot when I lived in CT.
There is a good cam to check on conditions. http://cam.warmwinds.com/surf_cam.php
I'm from Connecticut and live in NC now. I would drive to Long Beach, NY. Place goes off. Depending where you are in CT, LI was closer for me. RI maybe better if your further east. Isn't misquimicut in CT?