The scanner lenses will only work [well] within a narrow range of magnifications. As a starting point, 0.8X to 1.6 or thereabouts. The narrower range the better if you achieve changed magnification by using a focusing helicoid. By trial and error found I could run my LS-4000ED scanner lens at m=1.5 (1.5X) with good results. Focus stacking is almost mandatory if subjects have any depth to them, since the depth of field is so paper thin.
I have a Laowa 100mm f/2.8 that in a pinch can go towards m=2, but working distance becomes too short to allow a lens shade. Thus I stop at m=1. The Olympus OM 38mm f/2.8 adapted to Nikon mount can do m=1.7-1.9. It is also very robust and can be deployed under rough field conditions so is my preferred travel lens. For further magnifications, the Laowa 25mm f/2.8 covers m=2.5-5. From then on the solution is using Mitutoyo metallurgical objectives and infinity focus tube lenses for m=5, 10, and 20. Anything m>2 calls for studio work. m> 50 calls for a microscope in most cases.
The magnification m~1.5 is in fact very useful for my work, as it is sufficient for documenting infestations of rust and smut fungi, plus minute details of my aquatic plants. Thus I use the scanner lens approach quite frequently. I put an improvised "lens shade" on it using a C-mount extension tube, and also carefully blackened the interior of the adapter to Z mount because this lens is quite susceptible to flare and stray light.
