Don't take this wrong, but that's like asking what sort of car would be good to drive 1000 miles?
Too many particulars are being left out: format(s) to be scanned, desired resolution of image scans, desired end image format, etc., etc.
Chances are, what you want will place you in the lower-end of motion picture scanners which start at $30K USD and go way, way up from there.
Do some research and see if you have trouble believing me; its well documented on the Internet.
Most people wind up sending their film to be scanned, and even that his not cheap at all.