Define small. when we were is g7 for a year we had a small bus that measured just under 24ft. I think it was 23 feet 10 inches. I emailed the cyclone club about vehicle length limit as I knew we had a biggish vehicle. I was told 24 ft. Printed off the email and took a tape measure just in case we were ever given grief. Never was an issue.
They say as long as the vehicle fits in a traditional parking spot you are good. Yes, even in g7 with the extra space, this is the rule.
Some things to consoder if you go the g7 route.
But, as others have noted g7 doesnt allow over night parking. Best bets would be haunted forest or vet med. Vet med opens 5 the evening before. Not sure about haunted forest.
Walmart parking lot maybe hy vee would always be an option to sleep the night before then get up early and move to g7. But that is fairly white trash. But also free. I would call the store to make sure it would be okay to do this though before just showing up.