For studio work at say 5 to 10X magnification, using a flat-field infinity corrected APO objective such as those from the Mitutoyo M Plan series in conjunction with a tube lens yields image quality at least as good or very probably better than what any finite-focus lens, even the famous Macro-Nikkors, can deliver.
In these infinity-corrected systems, several additional issues have to be sorted. Firstly there is a need for a quality tube lens of focal length 200 mm. A 200 mm lens with telephoto construction works pretty well; a highly corrected close-up lens such as the Raynox DCR-150 might be at least as good, but much cheaper. Secondly, as there typically is no aperture control, depth of field is very limited thus focus stacking is required in virtually all cases. And thirdly, flare from external light sources can be troublesome unless you carefully shield the front of the objective, or due to the setup for the tube lens, there could be internally generated flare to cope with as well.