First off, it’s great that you’re looking to preserve those precious memories from your grandfather’s negatives. With your Nikon D750 or Z6, you’re pretty well-equipped to handle this project. The Tamron 90mm f/2.8 Macro lens is a solid choice for 1:1 magnification, offering the detail needed for high-quality scans.
Before diving into gear recommendations, let’s address how these negatives are stored. Are they organized in pages with 4-6 frames per strip, or are they in rolls? This will influence your scanning process significantly, especially in deciding whether to scan entire strips or select specific frames.
Regarding the quantity, it would help to know how many are mounted slides, color negatives, and black-and-white negatives. This impacts the scanning method you choose.
For 35mm film, scanning at more than 30 megapixels typically doesn’t provide additional detail, so your camera setup should be more than adequate in terms of resolution.
When it comes to speed, your setup design will greatly affect how quickly you can move through the scanning process. A good, rigid setup means you won’t have to refocus the camera for each strip or roll if they’re from the same stock and have similar curvature.
I’d recommend considering the VALOI 360 with the Advancer, as it’s user-friendly, especially with shorter strips, and it keeps the film flat, which is crucial for consistent quality. If you’re going for a more robust setup, the CS-Lite combined with the VALOI 360 holder is a fantastic choice CineStill CS-LITE Camera Scanning Light Source with VALOI 360 Film Holder Bundle 95+ CRI Light with Film Holders For Digital Camera Scanning – CineStill Film. The CineStill CS-LITE provides a stable light source, and with a sturdy stand, your camera won’t drift or tilt. Just make sure the setup is rock-solid to avoid any movement during scanning. Check out these options online, like the bundles offered at CineStill Film.
For a DIY angle, browsing through forums and resources like film4ever.info can give you great ideas on how to build or enhance your setup. Vlad’s Rigs Gallery, for example, offers insights into custom setups that could be tailored to handle large volumes of film efficiently. film4ever.info - Vlads Rigs Gallery or film4ever.info - Vlads Rigs Gallery
As for Negative Supply - their holders are good, but they are too long to my taste. The set sold at FPP store is lacking mechanical stability IMHO.
For higher throughput, something like the Nikon ES2 might not cut it due to its throughput limitations.
Good luck, and enjoy the process of bringing those old memories to new life!