Cary;
Depends on what you mean by "best weather." The warmest, driest, sunniest months are July/August.......also the daily patterns of fog early, high winds through the day....those great links golf conditions.
The months of October have slightly cooler temps, with a shower or two, but far less wind than summer. The weather in the early fall simply sparkles, and with dry and firm conditions............my favorite season here on the coast.
Tom