September should be nice; fewer tourists, and the weather in the daytime should still be okay. And it might be the beginning of the harvest in the vinyards of the Niagara Peninsula.

Of course, if you want cold, you could go in December and help with the ice-wine grape harvest...

IslandCub