I really can’t comment on off-road riding and brake needs, I am 95% road and 5% gravel roads, but I can lock up my carbon rims in the wet. I have never been terrified with a dual-pivot caliper.
Now I do have a a bike from 1933 with long-reach single-pivot calipers with cork pads on wood rims. I recently did a challenge ride on it, 1000 ft of climbing (and descents) for every 10km. It was raining that day. On that day I certainly was concerned. 
And I’ll take 27mm tires at 75-85psi over 23s at 100-110 any day and in any condition.