The US is a huge country. In general it has excellent water; the US averages better than the EU. The Environmental Performance Index is a report that measures many things, and they have a handy section where they measure DALYs lost from sanitation and drinking water. For this section the US scores 96, within a few points of Switzerland (100), Sweden (97), Austria (96), Denmark (94), Belgium (93) and comfortably above the Netherlands (91), France (88), Poland (80), Czechia (79) and Japan (78.)
There are isolated incidents of poor water quality in each of those countries, and especially in small towns of eight hundred people in rural areas, but generally speaking, clear drinking water that is free of bacteria is standard.