You're comparing water taken from the Floridian aquifer (lots of minerals like sulphur, which isn't known for tasting great) with Seattle (water from the mountains), SF (hetch hetchy), etc. I just want to suggest that maybe the taste of water is one of the things that cannot be naively mapped to a linearized space of red vs blue.

I use a brita water bottle for places with gross water. Actually use it in Orlando regularly. It usually takes most of the swamp taste out but even it cannot fix the horrid water at Cosmic Ray’s.