All of my macro work with digital cameras is done with older manual focus lenses -- not only because I already have them, but because auto-focus has a problem with macro shots.
This used to be true for DSLRs, but the opposite is true with mirrorless cameras with on-sensor PDAF. When you have 4+ rolls of 36exp each and you want to take advantage of 50MP+ sensors, autofocus will beat any human because humans are lazy and not consistent. You can't 100% perfectly nail focus 144 times in a row.
@Stephen McAteer GFX platform is not ready for film scanning. Sony A7R IV or V with Sigma 105mm f/2.8 Art Macro will beat it. I have owned both and sold the GFX. Awesome platform. Awful tethering options. Awful lens choice for film scanning.
In terms of color, I can easily match the output of Flextight X5. I spent a ton of money with my local lab giving me raw uninverted scans from their Flextight X5 and they are not superior to Sony A7R IV in any way. Look at my posting history, I shared some of my samples earlier. I am not aware of any solution under $15K, new or used, which can beat the Sony + Sigma + Negative Supply combination. When/if Fujifilm releases a comparable 1:1 macro lens for GFX, I'll switch back.
The previous paragraph covers the hardware. But software and image editing skills play a huge role. You have to get that covered if you go the camera scanning route. There's ROI considerations too. Let's be honest, 99% of our images are not that great and will never be enarged that much. But for a few lucky masterpieces you can send your film to
@dokko. His custom machine appears to be magnificent and will beat any hardware you can realistically hope to buy!