I'm a bit of a tap water connoisseur, and tap water in the US varies greatly. I grew up in the northeast US, in a town where the water comes from a mostly spring-fed lake. The water has zero chlorine taste or smell. I currently live in another town in the US where the water mostly comes from a local reservoir, and also has no taste or smell. In both cases, water pipes are buried to avoid frost, resulting in cold water from the tap all year.
San Francisco area also has surprisingly good tap water, likely due to the clay/soil in the areas the water is sourced from. In other places, like Florida, minerals and sulphur give the water a distinctly unpleasant taste, and shallow pipe depth keeps the water from getting cool.