This September and especially October were about the best we ever had for fall foliage. I think of October for leaves and then November for berries.
I have been using Euonymus europaeus and Ilex verticillata and Celastris orbiculatus berries. These are the "flowers" I have done recently for the West Newbury Church.