Actually our tap water (Denver) is quite good but you are correct. I have traveled to places where the tap water was awful.
Worst water I ever had was New Mexico gyp water, with a high level of gypsum in it. You could drink it as tea or coffee, but alone it’s horrible.