Well water is fantastic. I can notice the difference city to city and have since switched to certain types of bottled water. Making ice cubes with bottled water makes drinks taste differently.
Toronto has chlorine plants and ozone plants.
(And from my darkroom days, I'm fairly good at nailing 20 °C with my fingers, so I just waited for the tap to give me the right temperature and then poured it straight into the pots.)
Low pressure, extremely hard to the point where soap is useless and we had to replace things regularly from scale build up, the UV filter thing we had to run in the basement, the worry that one day you could randomly lose the prime on the pump and they'd have to dig to get it back (which happened once), no fluoride so my teeth aren't the best.
Give me that carbon filtered (removes the chlorine taste) city water any day :)
I think a common misconception is that your water runs through the salt. In reality, the water runs through a filter and the salt water is used to periodically flush the accumulated metals out of the filter. This could lead to some residual salt, but it will get flushed away quickly. The other source of salty water is a busted valve. Replace it and the water will be fine again.
Where was this? Pumps are placed at the bottom of wells and avoid this problem entirely. It's physically impossible for a pump placed at the top to raise water more than 10m.