Well, Well...

If I was on a well, I guar-an-dang-tee you the water would be tested regularly. We become accustomed to the taste of the water we use regularly, and do not notice the taste. Sort of like not noticing our speaking accents. And all contamination does not affect taste.
Anyone with a well should do regular testing, just like the city boys and private utility companies, and HOA's do. Write it off as part off the cost of "free" water.
I think of Ward Transformer, PCB's, and sub-surface hydrology when I think of a well.
I think of Neuse Crossing(I think that is the right subdivision) off Mitchell Mill Road and the mess they all went through when the community wells were deficient.
I've seen too many wells and septic systems on small lots to make me comfortable. It isn't an "overflow" that concerns me. I'm much more concerned by the possibility of ground water contamination in concentrated small lot areas.
I come from coal country, deep mines and strip mines, with gas and oil wells, too.
Ground water becomes contaminated many different ways.
UST's, Underground Storage Tanks are another pollutant issue, and can affect a wide area. Then there's MTBE from your old corner gas station. The subsurface plumes can be VAST.
All in all, I am comfortable with City water that is tended, and tested regularly, by people who are highly trained for the job and work full-time at it. Tastes like water to me.