I've been visiting and working with engineers, operators and maintenance guys at several major municipal water treatment plants over the last 15 years. What I've witnessed and heard would make many of the die hard tap water users rush out and buy an RO or RO/DI unit asap, or look for alternatives to using tap.
I've seen things that would make you cringe - and you wouldn't believe the EPA violations that are covered up. Believe me - the water we think is pure out of the tap is not always what we think it is. And that is the difficult thing about tap water - you just don't know. Also, from the time it is treated, tested, moved through distribution piping, and then ends up coming out of your faucet - there are many sources of contamination that can occur.
If you are not testing for every compound that could be present - you are assuming, speculating and just having faith in your water company.
So in my opinion - in order of worst to best regarding removal/reduction of contaminents, and giving one some level of control over their water quality for saltwater tanks, and their own personal drinking water.
1) tap water
2) store bought distilled water
3) store bought distilled water with carbon filtration, or other forms of secondary filtration
4) store bought RO water and it's various forms of additional filtration, polishing, etc.
5) home DI unit
6) home RO unit
7) home RO/DI unit
Each step up gives you "some" level of control, assuming you maintain your equipment and continue to test.