For the past 5 or more years, the accepted standard workflow for professional sharpening has been a three step process first described by Bruce Fraser.
There is a very nice summary of this technique here:
http://www.cambridgeincolour.com/tutorials/image-sharpening.htm .
If you like the above summary, buy his book and help out his widow:
Real World Image Sharpening (2nd Edition)
If you want the most simplified version of the above that will still produce reasonable results:
a) completely omit the "capture sharpening" step;
b) take a decent enough photo so that you don't have to use "creative sharpening"; and,
c) use the Image / Image Size / Bicubic (best for smooth...) tool in PS6 / CS6 to do all of your final down-rez'ing for web, email, etc. Don't use "Bicubic (automatic)" or any of the other options like Bicubic (sharper). And, if you are stuck using CS4 or earlier, still use "Bicubic (best for smooth gradients)", but you will have to apply a little final sharpening, preferably using Smart Sharpen.
Be cognizant of the fact that different images, even if equally well photographed, demand different sharpening, eg, consid sharpening a photo of a baby vs sharpening a wonderful cross-lit landscape.
HTH,
Tom M