If anyone is looking for a weekend trip in October in the Midwest, consider making a trip to the Circleville Pumpkin Festival (http://www.pumpkinshow.com/).
When I lived in Southern Ohio I always loved this festival and think it is one of the best truly Americana festivals around. Everything from Pumpkin Chili, Pumpkin Ice Cream, Pumpkin Donuts, to Pumpkin Hamburgers. Amazingly great food, entertainment, and parades every day. Southern Ohio is a beautiful place, especially in the fall and there is plenty to do in a weekend.
Closest Marriott properties I believe are in Columbus, roughly a 35-40 minute drive