Well, I would not say " stay away," because there are so many wonderful places to visit and people will want to go for the fall color.
But I did think it would be responsible to let people know about the water situation, because it can cause numerous issues, including health issues or water pump failure etc.
But it would be wise to be cautious about having a good filter system and checking it often, which I did not do because I was not expecting them to be so dirty so quick. I could have changed those sediment filters more often and showed the campground managers/owners and extended my whole house filter use, if I had. My bad.
I have encountered bad water in other locations, but it is usually older parks.
so campers beware! This is an issue you may not be able to know about especially if it is a brief stay. But it can sure cause a lot of problems. It took many gallons of water to flush the iron from my tanks and I ruined a load of clothes I washed in that orange water in Iowa. I flushed the hose first, but could not see rust...
And for the record, it was a KOA. I contacted the corporate office, but it took many emails to get a tepid response. I wanted my brand new filters replaced. But the campground managers were upset that I contacted corporate about that and only gave me a refund on my night stay. KOA after many many emails, finally sent me a couple of certificates for a free night of camping at a KOA to make up for the new filters that were ruined. When I pressed them about making this franchisee repair their water, I got the runaround... with corporate "language" for "don't worry, be happy."
I still stay at some KOA's, but they are not my first choice after my experience with corporate. Boy was I naive... they are more concerned about outward appearances of the campgrounds than infrastructure.