How bad is the weather in the fall?

Hey all,

My family and I are planning to come to the area this fall and just wanted to catch a local perspective of the weather. I understand September/October is generally hurricane season. We’re from eastern Canada and usually get the tail end of the storms.

From past years, is it generally bad last week of September/first week of October? Or would we be better to push it off until November?