I have several (too many) scanners. Mostly, I use these two:
— Fujitsu fi-5120c for high speed document scanning. It has a high speed automatic document scanner and a fairly fast flatbed. I use the flatbed sometimes for photographs, but I prefer …
— Canon CanoScan 9000F Mark II for printed photos or negatives. You might be surprised how little it costs.
For what it’s worth, if you do it yourself: Since the time you spend is great, I strongly recommend you scan at very high ppi resolution. If you’re never going to do it but once, you might as well capture as much detail as you can while you’re at it. High ppi takes only a tad more time to scan than low ppi.