A 1200 or 2400 DPI scan from a flatbed scanner will easily produce a 1000 x 600 pixel final image. You don't need to scan any higher than that. Scanning at higher resolutions is just wasting time and memory.
If the image is for viewing on the internet, scan at 1200 and edit. When you are ready to finalize, scale it down to the size you want.
If you want a "really excellent" image or if you are zooming in on a small part of the negative you can go up to 2400 DPI for editing and scale down to final size when done.
When I first got my scanner I scanned at maximum resolution (9600 DPI) because I wanted to experiment and see what my "new toy" would do but I quickly found out that, 90% of the time, I never need to go above 1200 DPI.
What is important in a flat bed scanner is versatility, reliability, ease of use and color rendition.
Does the scanner do everything you want it to do? Can you scan prints, documents and negatives with ease?
Does the scanner work as expected and does it work without breaking down too frequently?
Is the scanner easy to use? Do you have to install special drivers and fuss with it each time you want to use it or can you just turn it on and make a scan?
When it makes a scan, does it produce an image that looks the way you want it to? Are the colors true to the original media? Can you calibrate it so that it will produce true colors?
These are the questions I think you want to ask yourself when considering a flatbed scanner. If you want that "razor sharp" resolution, you are going to have to look at a dedicated film scanner. As a hobbyist, I think your best "bang for the buck" is in a flatbed.
After you get some experience at scanning and IF you decide this is necessary for the work you want to do, then you can get a film scanner.
PC Magazine is a good place to look for equipment reviews:
http://www.pcmag.com/article2/0,2817,2352852,00.asp
But you can Google "Canoscan LIDE 700f" and find a dozen other reviews.
I'd say the Canon is a decent product for the money. Epson or Nikon are other brands you should also consider. Just read the reviews.