Living in Windsor, Ontario, Canada, I can confirm that our water is extremely clean and good to drink. Additionally our city was rated one of the best tasting tap waters for all of Ontario, cities literally compete for quality water. Contrast that to Flint michigan across the river from me.
I think for some people this might seem to be true. That said, for folks who are able to taste such things, clean water from different sources definitely can have tastes that differ based on the minerality of the water.
I used to think this was BS, but I changed my mind after doing a deep dive into wine, in which flavors like minerality of the soil, local flowers, and the like are definitely represented in finer wines.
For an over-the-top water example, check out this video:
In Germany, every supermarket has dozens of different bottled water brands. The vast majority are not fancy and are on the lower end regarding price. You can taste your way through the different mineralisations, from kind of dry tasting over sweet to salty. It's not a surprise the guy introducing Americans to the varieties of water tastes in your link is German.
