I've done this ride just about every year for the last four or five years and it's my favorite, so of course I'll be there. Even if it were to be raining I would still drive there just to get the great long sleeve t-shirt with the painting of the covered bridge. If we're really lucky the foliage will be close to peak and your biggest concern will be keeping your eyes on the road.
The only problem is that it's becoming too popular. For the last two years I've brought my own food for after the ride because the lines are pretty long at the food tables. Oh well, I guess you can't have everything.