Historically handheld scanners where much bulkier than those, and as you say did a poor job, but maybe things have improved. A good scan used to be as much about a steady hand and smooth motion as it was about how good the technology was.
If I could think of a good excuse to use one at work I'd get one to experiment, but I can think of a way to justify even spending a couple of hundred quid on one!