Isn't it 'funny', when such basic requirements arouse so many issues, because half the time, the kit we all fork out for is presumed all-important, but in reality, is just like a spare 'relation', i.e., nice to look at, but does it actually do anything!
I have actually got a Canoscan, but it really went south after a few years, and the belt began to slip, so while whirring happily away in the corner of the room, it wasn't actually scanning anything other than the first millimetre of the page!
I actually made a photo scanner for an iPad, and have done around a thousand pics as you say, Lards, and the originals are in better storage boxes than fifty or so creaky/smelly old albums, but as I'm an inveterate collector of other stuff for digital storage, and don't have an office any more, an all-in-one machine is the way to go!
Mrs B, you can use your iPad to scan any picture and save it to look at later! A basic and free app is
https://www.appinitio.com/picscanner/ Pic scanner, and is very easy to use!