For those of us who have yet to enter the current century and still have to get a digital camera, could someone fill me in on what resolution we all scan at?  I usually scan pics at 1200 dpi, to ensure a good quality, but I think this may be a bit excessive.

Anyone else?

I bought a scanner (flatbed) and rarely use it, it scans great but the software it runs on sucks and is time consuming.

But to your question I have "presets" for photos, text, etc.
And usally scan a photo at the default scan rate which is 1200dpi, I have tried it lower and found that there really isn't that much differance except for the fact that some of the originals flaws aren't as apparent.