Its a defense mechanism initiated by your taste sensors. Very sour or spicy foods are irritants and trigger your mouth to secrete saliva in an attempt to dilute/reduce the effect of the irritant.
The exact level of sour that triggers this response almost definitely varies widely from person to person, just as different people have different tolerances to spicy foods. So I would assume that there's no perfect strategy for achieving this effect. I'm sure that the drier the beer is, the more pronounced the effect is in general, since there's less sweetness to counter-balance the sour. But there's probably not a definite quantitative number for producing a really mouth-watering sour, since it will vary from person to person. I doubt there's a huge difference between lacto or pedio, since both produce lactic acid, but maybe there are some subtle differences in other side products they produce that may enhance the perception of sourness...don't know.