For my part, as a lifetime South Carolina resident, October and November is the best time of year for golf. Most years even up through Thanksgiving weekend you'll get cool overnights (and the possibility of frost delays) with dry, breezy daytimes. High temps will probably be in the 50's to maybe low 60's and it'll get down near freezing some nights or stay in the 40's on others.
But the temps are highly variable. It is possible to dip into the 20's in mid-November and it's possible to have an odd day or two over 80F. Mostly the humidity is low and the golf courses are in great shape, just on the verge of going dormant but still healthy.