For reproduction works the ideal lenses are those labelled as "bellows" lens. They typically have no focusing helicoid and I suppose often they don't have the diaphragm simulation (you focus and the manually close the lens to the working aperture).

They are specific for reproduction work, and are especially corrected for distortion and field curvature. In principle they should work better than ordinary macro ("micro") lenses for reproduction work.

Canon, Nikon, Minolta and probably many other producers produced them. You can use adapters ring as you probably don't need any diaphragm simulation and you will not have any issue with focusing at infinity, so you can use any lens on any bellows (or tubes).

Another alternative to try would probably be enlarger lenses used as bellows (or tube) lenses with adapter rings.