October 6-8 is Columbus Day weekend. You will most likely need reservations for that weekend. It's the "last hurrah" for many campers and many of the campgrounds shut down then. That is a great time to be down there-school is in session, weather is usually very nice and it's an underrated and overlooked place for foliage. You will most likely be to early for that but that will be dependent on when the cool weather returns. We liked Peters Pond Park but it's been a long time since we've stayed there. It's on a fresh water pond and gives great access to the upper Cape.