Not OP, but any macro lens will do the job. You're not likely to be shooting at a wider aperture than f8 given that you'll need some depth of field to spare. (Even if you use a specialised copy lens with a flat field, the film won't be perfectly flat anyway.) So given that you're shooting an imperfectly flat piece of film at a narrow aperture, differences between lenses will be small. I use an ancient f3.5 Micro-Nikkor. These are cheap and plentiful in the second hand market and can be adapted for most cameras.

As far as the camera is concerned, it's a big advantage to have an electronic shutter. The effects of camera shake are magnified with macro photography, and a mechanical shutter can make the results observably softer. I am cheap, so I use an old DSLR in T mode and use a Raspberry Pi to turn on one of those backlit sketch pads for a fraction of a second to expose the image.

To add onto this - I highly recommend you take advantage of light rooms Flat Filed Correction tool, it will eliminate lens vignetting which can cause issues when inverting. This article elaborates https://www.pixl-latr.com/defeating-the-orange-haze-lightroo...

That looks very useful for use with older lenses. With a modern lens, shouldn't Lightroom be able to apply a precise vignetting correction based on the image metadata and the lens parameters?