.....We have recently purchased another boat and will be sailing in Narragansett Bay for a year or two (trying to sell our farm in central Mass), but am already missing Maine......
We love both and can't wait to get back to Maine. To be fair, if you want to be warm, you have to be in Penobscot in Jul or Aug. We were there in late June and felt in character in our foulies, with cold misty fog and rain, but would come the next time in warmer weather. There is something special about the pace of Maine.
Narragansett and vicinity has many great places to sail as well, but its certainly different. The Newport area gets very touristy, but there are more remote places. Although, you'll never be without neighbors. Within a half day's sail, there are more destinations than one could really get to know in a lifetime.
Sounds like you are already familiar with Narragansett, but if you need any advice, just ask. I'm not a walking encyclopedia, there are places we've never gotten to in the 20+ we've been coming here. But that says something in itself.