Standalone flatbeds can go up to 6,400 dpi, which provides a much higher level of detail.
(Not to mention dependent on a steady hand.) Portable document scanners and all-in-one printer flatbeds produce better-looking scans but are typically limited to 600 or 1,200 dpi resolution.