I was reminded of the very high resolution you can get from an inexpensive flatbed scanner recently when there was interest in a large print from one of my scanned flower images. With both the images shown here, the basic image was created on the scanner but I also photographed the flower, and blended the files from the camera and scanner.
Generally, flatbed scans can give you a very high resolution, but depth-of-field is very shallow. There’s no way to adjust depth-of-field, as you do by stopping down a lens. The ability to capture depth is also limited. If you try this technique, expect to spend a great deal of time spotting out dust, which almost always accompanies scanner images, particularly if you use a black (or dark) background. Combining a scan with a photo in some ways gives me the best of both worlds!