During the 20 years I worked in a lab plus my home darkroom for 50 I've never used anything but tap water. It was typically run through a particle filter but but that was the extent of it.
I actually asked because I hadn't seen it mentioned and thought their might be a reason why some people had to use bottled rather than tap water.
Of course, your evidence of 50 years is only anecdotal -- but it's the anecdote most people will tell (though it's only 40 years in my case), so it's evidence I'd give real weight to.
My suspicion is that those who worry are the victims of classic internet paranoia. "One person in 10,000 (or 100,000) has a problem? It's gonna be ME!"
On top of that, I betcha that a substantial minority of the people who think they have probems with the quality of the water out of their taps are doing something wrong somewhere else in the chain, which is causing a problem independently of the water.
It's a bit like dyslesxia. Dyslexia really exists, and can be a hell of a handicap (though a surprising number of the dyslexics I know are successful inventors or run successful businesses). But dyslexia is also a convenient way for pushy middle-class parents to pretend that their kids are something other than stupid or lazy, so it tends to be somewhat over-diagnosed. Likewise, 'bad water' is easier to blame than 'I don't really know what I'm doing'.
As discussed elsewhere in this thread, photographic chemistry and physics are staggeringly complicated. You need to understand a fair bit of physics and chemistry to begin with -- more than most people do -- and then you need to read a lot of very chewy texts and papers on the subject. Then, even if you do go through the physics and chemistry, it's deeply unlikely to improve your photography. This is why I tend to give up on the fine detail -- often, I can only just understand it if I think hard about it, and there are other things I prefer to think hard about. As Marty has pointed out, the only real reason to go much beyond the empirical is intellectual curiosity. But on the internet, as in real life, there are
always people who think they know more than they do.
Cheers,
R.