Certainly EP 316L is the standard for high purity water systems.
The most critical thing is how the welding is done, and how the welds are cleaned.
Any heat tint can be a problem and passivation cannot remove that.
Another thing that gets overlooked is the use of SS castings, commonly in valves and pumps.
Castings are fine, as long as they have been solution annealed and certified as low residual delta ferrite.
Of course that goes for the tubing also, the long seam welds should be >0.5% ferrite.
I have seen testing over the years that points to the micro surface finish being more important than the macro.
People fixate on Ra because they can measure it, but it is not very significant. I can EP a rougher surface and remove the microscopic features and get much better pitting resistance.
EP works because;
1. smooths the micro-surface
2. selectively removes less corrosion resistant material
3. leaves a very clean surface
There are not a lot of other good alloy choices. The only other thing available in the marketplace is AL-6XN, and it is way overkill for HP water.
In cold systems I have seen FRP used, but you have to be very careful there also.
= = = = = = = = = = = = = = = = = = = =
P.E. Metallurgy, consulting work welcomed