What I do, in case any of it is of any help...
I spend the least time on prints taken mostly of our kids that are still usable, starting by using an Epson DS-410 document scanner. It's one of their cheaper models that I picked up on sale, has a max dpi of only 600, but as far as I can tell the working parts & optics aren't much different, if they're different at all, from Epson's more expensive models. What it does lack is the software that comes with the photo version of their doc scanner, but the driver provided does work well enough once settings are adjusted from the defaults, which are designed for OCR with B&W documents. [I'm anxious to try it with the VueScan software I recently bought using an Xmas gift card, but I've still got ~300 photos I'd previously scanned to go through. Ouch!] Using a doc scanner is SO MUCH faster than using a flatbed, but it has a downside... even though I do my best to clean the prints 1st, dust &/or debris always finds its way onto maybe one out of 10 prints, and when that happens, it gets onto the scanner lens and leaves streaks across every scan from then on. So I scan 5-10 prints at a time, checking each one is Windows Photo Viewer, starting over when streaks appear, cleaning the lens with a soft paint brush. Even using that admittedly tedious approach, I'd say using the doc scanner is at least 10x faster than using a flatbed.
I've used an app called Photolemur [that's now free if you can find it] on a few thousand to just make minor improvements, making sure they're viewable, saving the original scan to go back to if I later want to give any of them the full treatment. With the photos I'm working on currently I've used the noise removal in the GOTD DVDFab Photo Enhancer AI, which for me was a HUGE eye opener. I've since found that it can leave anomalies, small areas of distortion, that may even have been fixed by an update, but I'm reluctant to go through 300 photos a 2nd time to find out. Once my eyes were opened to what AI noise removal can do, I picked up one of the 2 alternatives available for a good price during a holiday sale, Topaz DeNoise AI; it also has a P/Shop plugin, making the workflow faster.
I pay the $10/mo for the current Photoshop & Lightroom package. Opening the .tif file saved from the DVDFab app, I 1st do a crop, then a levels adjustment. Next is a color balance adjustment layer if/when needed. Then I'll create a combined layer [Ctrl + Alt + Shift + E -- I remember it as CASE], zoom in to 300x, and use the healing brush on any scratches etc. Saving a copy [as a fail-safe] I'll then use the Luminar Neo plugin [I preordered it for 1/2 price last fall], making a few quick adjustments that do make a noticeable difference [I Love the Relight option on some snapshots]. Then I save the result as a jpg, alongside the original .tif from the scan.
* * *
I've just started working with negatives again... I bought a Minolta negative scanner years ago, but found using it too tedious, because the all too visible grain on scans required so much work; I wrapped it in plastic & packed it away. I bought the scanner so long ago -- I had to buy a pci card for the then brand new USB 2 (!) -- I had forgotten how bad the grain issue was, and I bought VueScan so I could use it again. The new AI noise removal saved me from packing it back away -- using that software seems like a miracle. The relatively few scans I've done got the same treatment as our old prints.
Before I revived the negative scanner I made a rig to use my camera. I found that I could buy all sorts of rails & related parts on eBay cheap, so it was fairly simple to mount a tripod ball head on a wooden base, & attach a mount holding 2 short rails to that. I have a camera mount designed for macro photography that slides along those 2 rails, and it has a manual gear driven slide that allows fairly precise back & forth adjustment. The harder part was cobbling together the assembly to hold the negatives. I found and modified a negative strip holder that was made for some scanner, modified a small lightbox that was designed to attach to a camera lens to take photos of slides, cut up a black velvet gift bag to use as a bellows to keep out stray light, and mounted it all to a wooden base with a lamp head using a daylight flood light bulb behind it.
In some ways it's quicker than the negative scanner, while relying on optics I don't have the same grain problems, but processing takes work; I use an old giveaway, ON1 Effects, to turn the negative image into a positive .dng RAW file that I then open in Lightroom. I like doing that better than making the negative -> positive change in Lightroom, since I feel that limits what I can do with the photo from then on in Lightroom. OTOH, while I can move a small tray off a small table next to my desk, and use the negative or doc scanner there, setting up and using the camera rig is a project taking up an entire afternoon or evening -- I just don't have the space to dedicate to that sort of thing.
* * *
The old, inherited photos, some from the 1930s, get the most work. I sandwich prints between non-reflective plexiglass [meant for picture frames] and white cardboard. I put that in a folding photo booth affair designed for photographing items you intend to sell online [there are all sorts these available on Amazon]. For lighting outside the translucent box affair I use small LED lights for photography / videography mounted on small tripods. I then use my camera mounted to a tripod that has a 90 degree arm -- something like this:
https://www.amazon.com/360°Horizontal-Rotation-Professional-Projector-360°Panorama/dp/B07C1PXQVS/ref=sr_1_11?crid=254KCF1DV062V&keywords=photo+tripod&qid=1645207696&sprefix=photo+tripod%2Caps%2C78&sr=8-11
I'll try to clean each print, then mount it to a sheet of paper beforehand -- one sheet usually holds several -- so swapping photos in that sandwich affair is quick & easy. I then move the photo sandwich to bring individual photos into the frame, taking photos of each using a remote trigger, so I don't cause any wiggle. That way I can photograph several dozen in a 2-3 hour session -- most of the time involved is in setup & breaking that setup down afterward.
Doing it that way is faster, & I *think* higher quality than using a scanner [and my Canon goes to 48 optical], plus I get to work with RAW files; since they're all the data from the camera sensor, more adjustments are possible. Then it's on to Lightroom, where I make most adjustments, sending the photos to P/Shop for the final work. Since most adjustments are already done, the majority of the work there involves repairs. The most tedious part is what looks like a ton of dust, but is really I think where the photo has been worn away -- they've been in shoeboxes & such, moved around for almost 100 years. I'll add a duplicate layer, applying the dust & scratch filter to get rid of 90%+ of the problem, then use a mask to hide that layer. Then, painting on the mask in white, using a tablet, I'll dab the individual dust spots to make them disappear. Applying the dust & scratch filter at the levels needed greatly reduces the image's sharpness, so this way I mostly avoid that. After that P/Shop's healing brush usually takes care of any remaining blemishes. One option that I think is really cool with some of these old B&W photos is the relatively new [greatly improved in 2022] neural colorization filter. [I sent my sister some prints I had made of colorized photos of our parents, & she was thrilled.]