I'm not as experienced as others here, been brewing for a while but only have about a year of dialing in mash chemistry behind me. So for what it's worth, I only take the following into consideration, in order of importance, highest first:
- Mash pH
- Source water alkalinity
- Cl / SO4, both measurement and ratio
- Ca
- Na
- Sparge pH (would be higher on the list if I fly sparged)
- Source water pH
- Residual alkalinity only if it is in the high positives (it never is)
I don't take any other measurements into consideration.
I need to know the profile of my water source. If I don't have this information for whatever reason, I'd be shooting in the dark, so I'd use distilled. Even with RO, I'm not sure I'd really know enough.
I only use lactic acid (would use phosphoric if my water had high alkalinity), gypsum, calcium chloride, table salt and (rarely) chalk for modifications.
I use the water calculator at Brewer's Friend and sometimes Bru'n Water if I need another input.
This is an over-generalization, but for the most part, the lighter the beer, the more distilled water I use. My tap water is a pretty good starting point for most styles and the source rarely changes.