No experience personally, but my mother (in her 90's) was raised on the farm in Missouri and they were in wide use everywhere. I would say it would be 'OK', but for nothing for drinking or personal use.
That being said, I had a college class on water pollution and waste management and one thing I learned was that ALL air pollution becomes water pollution. Keep that in mind. In a highly populated area with a lot of industry, the water may contain many pollutants. Ground water tends to be purer due to the filtering process through the medium (soil, etc.) to where it collects (hopefully not shallow wells). Here in SW MI (not so 'pure michigan') we are know as a 'cancer alley.' All the fallout from Chicago/Gary, etc. If you're away from that stuff, you should be ok. Another thought, you could always have a sample taken and analyzed. The county your in may do it, but don't tell them it's from you're well water you use, that way if anything comes back with flags, they won't think you have a drinking water problem. Hope this gives you sonething to think about.