Trying to start camera film scanning at home, which lens do I need

If you look at the last few posts in this thread you can download excellent scans from the Laowa 65mm f2.8 Macro, top end results for APS-C with Vlad’s Test Target. Certainly worth considering, manual focus instead of AF for the Sigma.