Being a certified water treatment plant operator and manager myself I would not hesitate to drink the tap water anywhere in the US. I used tap for the first 15 years of my saltwater fish only hobby and 10 years of my reef hobby and other than fighting constant algae problems things were pretty stable. At the time our water sources were 100% deep wells and in the early years we did not even chlorinate the system.
The Utility sold to the City and sources changed from wells to treated surface water and the battle was on. I almost quit the hobby beofre finding a Water & Ice store that actually did a good job even though it was RO only. They were able to take the then 680 TDS water down to 13-15 TDS which I was very pleased with and my systems improved dramatically.
I finally bit the bullet and bought a RO drinking water system for our home as they were going through bad MIB and Geosmin blue green algae phases and were bringing on a new untested surface water plant so our water quality sucked and it smelled horrible, you gagged when you got in the shower. MIB and Geosmin are so pungent even a few parts per billion is very offensive to the human nose. Once I had the RO things continued about the same but I was still lacking DI. I also got rid of the original RO and went to a AWI Typhoon III but was experiencing short DI life so that system wen taway and I invested in my first Spectrapure system. This is not intended to be a sales pitch and that will be the only mention of brand names but during all this process I kept log books on water quality, usage and component life and I documented the differences between one system and another and it was eye opening to say the least.
I have been using RO/DI for over 15 years now and would never even consider going back to tap. Again, I wouldn't hesitate to drink it but I feel stability is very important and you do not find stability in most municipal treatment and distribution systems.