I very strongly recommend an auto-feed scanner! I have tried flatbeds, negative scanners and commercial services. Then I found a used Epson FastFoto FF-680W auto-feed scanner, and honestly, I would never go back! The quality is excellent and they are unbelievably fast! You will save SO much time!
If you’re scanning family-type photos the source quality is never perfect anyway. Much MUCH better to free up time for organizing, labeling, tagging etc all the photos — and to have time to actually watch them with family and friends.
Not once has a photo been damaged for me. But even if that would happen to 1% of the thousands of photos: so what? Better that you get them digitized in a reasonable amount of time, than that you treat them like unique collector’s items. In my experience, if you dont scan the, now, the likeleyhood of them beimg just lost or thrown away in the future is very high.