You poor soul
Who did you pi%% off to get sent up here?
and you will find folks here and there to help you make the best of it. As others have posted, good spots are hard to find, and secret spots usually come with a blood contract (DON'T PASS IT UP!). Scouting every year during the off season is the key to a decent season, unless you happen to get lucky. I'm in the southeast corner of the state about 30 min from Groton and there is some decent areas along the coast and up the rivers.
The main game up here is deer, which get numerous due to all the non-huntable areas (neighborhoods, etc). I took up duck hunting because I prefer hunting wild birds (as opposed to stocked pheasants). Ruffed Grouse are scarce, and you're only allowed 3 Woodcock, so duck hunting became my 2nd best friend...but it can be pretty challenging at times. Due to work (and the subsequent lack of time to scout), my past few seasons are nothing short of embarassing.
If you hook up with some people for goose, you can have some wonderful days in Connecticut. RI does have a Dove season and you can hunt Sundays there...some people I know do a "Sunday Seaducks" trip to RI and have a blast.
I'll be interested in hearing how you like (or dislike) hunting up north versus your previous homes...I'm hoping it's a "grass is always greener" type of thing...no doubt there are some greenheads here, and plenty of swamps.
Good luck, hope you do well!