I've only ever used RO or distilled water and know I couldn't get away with using tap water without changing more often. Tap water in town is close to 300ppm and pH 7.5 or higher with high sodium and alkalinity. My tap water is worse as it comes out of a dugout on my property and runs around 400+ppm and pH 8.4.
I've always ran sterile in DWC too using peroxide for the first 10+ years then making a chiller out of a water cooler so found I didn't need the peroxide any more.
For sure you can have a lot of problems when you aren't experienced but that goes with any method really. I'm pretty certain that the majority of problems are related to poor water quality and always tell folks with deficiencies etc to contact their water supplier for a copy of their water analysis reports. All sorts of things in potable water that can build up in pots and throw everything off.
With hard water those minerals build up over time and adjusting pH to 6 or so won't make a bit of difference to the pH in the root zone when there is so much crap left in there from multiple waterings. Extra runoff or an occasional flush can help prevent buildup and save a lot of problems from happening. In hydro you should keep track of how much water is added back and change the nutes once you've added back as much as your system holds to prevent concentrating the minerals that are in your tap water.
Most micro-nutrient deficiencies are because of the pH being too high so I always recommend looking there first before tossing stuff in your pots. Generally makes things worse when you do that.
A big problem with soil or even soilless grows is getting a handle on the pH in the root zone. Testing initial runoff is meaningless as it's usually just a bit above what you are putting in at the top. The way commercial greenhouse growers do it is to water to the point of saturation first and discard any runoff. Then let them sit for at least 12 hours, add enough water to get some runoff and test that. That runoff should be caught in a clean container too so it's not influenced by anything left over from before. That will give a much truer picture of the pH in the pots. It can take hours before the pH stabilizes after a watering. With tap water in hydro it's quicker but a few hours before testing is best.
pH is a very complicated thing and I have a diploma in chemistry so most people have a lot harder time getting a grip on than I do. Easier to get it nailed down in hydro than in soil grows with all the other things in there.