Been on well water since we bought our house 22 years ago. I’m fine. We’re one of the few in MA that have soft water naturally. We test it every couple years.
I believe most well water is fine, that has been my experience. Most flowing water in areas that are not populated is also fine for that matter. I have known people that have had medical or dental issues though so depends on the source like anything else. I am not willing to drink untested and or untreated water with someone else choosing the source, that is just me.