Block Island is pretty great this time of year. Locals and sailors only it seems. Also, moorings are only $20!
Westbrook is nice but seems pretty dead right now. NY harbor will require a lot of motoring.
Why not go up to Southern MA. Buzzards bay/woods hole and of course hit up Newport and the Vineyard!
and take me with you!