Differences in weather patterns are pretty subtle throughout those months so I wouldn't plan a trip up here around that. I think August weather-all around, is the best, if you're sailing up for a couple-few weeks.
If you want the whole place to yourself, come after labor day(same as anywhere in NE).