If everything you will be doing is in South Eastern CT, then maybe Providence RI would end up being less of a drive to the places you are looking to get to.

But I think you would do much better if you forgot about SPG for this kind of a trip. Ther are many Marriott or Hilton type props all around to choose from, thats the main problem with SPG compared to MR and HH, no low level place to be found outside a major city.