I'll just provide my experience:
We had our own well water for 13 years. The water was 'very hard', it had to be filtered ahead of our clothes washer with filter elements needing to be changed frequently, a really messy job (ruined clothes otherwise.) We lost well-water supply during power outages, this can last several days or even weeks when a severe winter ice storm occurs. Our water quality (flavor) cycled from tolerable to terrible, we purchased bottled water for drinking and cooking much of the time, handling 5 gal jugs from town every week. Tests sometimes found farm-chemical contamination, a field is within 65' of our pumphouse. Then there was a water softener system to maintain and buy/handle bags of salt frequently, plus 'iron-out' chemicals. Oil wells in our vicinity added to our problems with two occasions of 'brine-water' leeching into our well resulting in ruining our refrigerator ice-maker and the control valve for our furnace humidifier (the leak went un-noticed requiring floor repairs.) Oh, we also had a 3-cartridge carbon filtration system under the kitchen sink to maintain. Wifey also complained of 'itchy skin' and 'hair-problems' after showering with the well-water.
We got 'city water' last year via a Dept. of Agriculture program for $500 hookup fee for initial subscribers (yeau, tax-payer supported -- thanks), but the system is managed by a local board of volunteer rural members. The water comes from a deep underground acquifer, is a reliable source even during storms, and its flavor is *consistently* great with 'no' chlorine or other chemical taste or smell. Our monthly bill averages $38-40, less than our well-water considering all of the above factors, and I'm certain the 'city' water is much healthier and convenient for us.
Most importantly of all, wifey is happy and we save thousands in skin and hair conditioning products.
I kept the well in service, needing to spend $200 for a 'new' used pump, bladder-style pressure tank and pipe materials -- only for garden-watering and exterior cleaning needs. I can always re-connect it (2 feet) for home supply but hope this never becomes necessary.
Best to all,
Mac