It really depends on the location. Every city has a different perception of their tap water in the USA.

Where I'm from we drink tap water with no filter etc.