For conversion I use Filmomat SmartConvert. It is standalone software you purchase once - no Lightroom subscription needed. You shoot in RAW and it will convert for you and export as JPEG and/or TIFF. The adjustments in the software allow you to adjust white balance, saturation and contrasts/density, which is often enough. When it loads a file, it automatically adjusts to what it thinks is best and you might only need a few extra tweaks to taste or none at all. If needed, you can do further editing in whatever editing software you use. Once I got the hang of it, I probably only spend a minute per file doing adjustments.
If doing 1000 photos an AF macro lens will be you best option. Mirrorless cameras tend to have more accurate contrast detect AF systems. I'm not sure how good your DSLR is but it may be good enough. The JJC film holder, with light source and tubes to connect to your macro lens is a good place to start. Mine came with holders for both negative film and mounted slides. For 35mm, I wouldn't bother with a copy stand or light table. That is more useful for larger film formats, where the volume of scanning is likely going to be lower.