I have camped at many places with bad water. The most memorable was one in south central PA that was back a quarter mile extremely dusty drive. When I arrive, I too flush the hose before connecting, so this time I sprayed the dust off the rear of the trailer. I noticed that the water was brown so I flushed some more with no improvement. Went over to the maintenance guy and asked about it and was given permission to flush till the water came clean. It never did and I never hooked up.
I have other stories, but I am convinced that most hook up without a clue.