It seems like folks buy a used Coolscan, scan their stuff, then sell it. They seem to last pretty well. I'm about to buy a used one to scan my Dad's old slides. And then sell it.
I could do that for my dad too...
I haven’t seen any consumer scanner that has an auto feed. Good ones have a nice sprocket wheel but you still feed manually with a wheel.
If you get one, have a look at VueScan on the software side - the original software needs (I think) a Windows XP virtual machine to drive it.