While I do seem to get an optimal adjustment setting, I still get front/back focus.
Okay, that helps to clarify. First, we need to realise that AF is not perfect. There will always be some spread around the optimal focus position, due to mechanical/electronic variations and specific optical input. The goal of the AF Microadjustment is to get the bias out of the equation, so we on average get a correct focus, with equal chance on front/back focus. Getting this bias correction right IMHO does help to get more
reliable focus, because I notice less jitter once focus is achieved.
Well I do get moiré at several settings with a best effect at a specific setting BUT when this setting is applied, I do not get better focusing results in real life situation than with a completely opposite setting (ex: best moiré @ +2 but settings @ +2 or -10 gives nearly same sharpness at autofocus target).
Okay, but with which autofocus target (you mentioned trying several different ones)? There is also quite a difference between calibrating e.g. a lens with an f/4 widest aperture, and an f/2.8 or wider one. The wider the aperture, the more visible the shift of focusplane will be. Also, the differences in the actual focus plane at adjustment settings of 10 or so, while noticable, are not huge. The adjustments are very fine pitched.
So to me it is inconsistent as I should get sharper focus at the best moiré setting and significantly worse focus on such a different setting. And I don't, I am no even able to tell apart the shots if not aware of the applied setting.
That is what I don't understand.
That is puzzling, I agree. Maybe we should tackle one specific lens, e.g. the 100mm macro, and see what happens in practice when you go through the full range of adjustments, say in steps of 10 (so use -20, -10, 0, 10, and 20).
The first thing you should notice is that the AF will focus on increasingly more distant positions on the focus ring. If it doesn't then the microadjustments are not functioning.
Secondly, when you make actual shots at f/2.8 on a tripod, e.g. close-ups of a newspaper at a 45 degree angle, you should see a shift of the AF focus plane. Do note that an angled surface is less useful for a calibration itself, but it could be used as a test of actual performance. However, there can be shifts of the focus plane that are due to the nature of the subject, not the adjustment alone. There should however be a trend as you make more tests at various adjustment settings.
Bart