We also went around Thanksgiving last year. It was mostly nice. A few cloudy days but warm. But we've been in November before and it was never cloudy. You can't say it's always a certain weather pattern each Nov. But you can definately have some cooler days than say mid summer.
We usually opt to go in November and December since it's not so hot and humid. You'll have a great time!