Erik,
Sharpening is potentially a big big subject, but...
Firstly, I'd recommend you check out publications and web based articles for methods.
The tutorials on this site are also excellent and very clear.
I personally 'started' with
Image Sharpening by Bruce Fraser and Jeff Schewe. I also have a copy of
the Digital negative by Jeff Schewe.
I think they will probably tell you more about techniques and how and when to apply than you probably ever need to know.
Ok, how do I fit sharpening into my workflow?
1)
in Photoshop ACR
I always apply a degree of sharpening. I generally apply an Amount of no more than 40-70, with a radius of <2 to avoid halos. With Detail I keep to low values to confine sharpening to main edges. I usually keep it low because I apply sharpening in one or two phases in Photoshop.
I always back off the impact of sharpening with the masking slider to avoid sharpening any remaining noise in the image(pixels to be sharpened are white if you depress the ALT key when masking.
I also reduce noise in the image using ACR but perform this after sharpening, but before moving to Photoshop for image presentation.
2)
In Photoshop
I perform sharpening in two stages, the second of which is purely a 'polish' for the final image.
Stage 1 is applied before any other layers (levels, curves, vibrance etc), are applied.
I usually create a copy of the base layer and then create luminosity selections for areas I want to sharpen. Typically I create separate flat areas such as sky, cloud and water since I do not usually sharpen these.
I then select specific areas based on the level of detail, eg rocks, foliage, structures, and apply sharpening based on the amount of detail. Essentially I separate areas to be sharpened on basis of 'high' or 'low' frequency. (High is characterised by lots of [fine] detail, and Low wold be areas without fine detail such as metal surfaces, smooth building surfaces etc.)
Most importantly I keep these on separate layers so they can be readjusted/replaced or removed if needed.
Stage 2 sharpening is applied after all other processing has been applied. It is not always necessary and as I said earlier is a final 'polish' to the image if I think it is needed.
For first stage sharpening I tend to use some home made sharpening actions, based on Gaussian Blur, Surface Blur, or Noise>Median filters. I think they give me a 'finer control' but that may just be me liking to tinker. Arguably Smart Sharpen or Unsharp mask can do the same.
For Second Stage sharping I always create a luminosity layer of the final image, and then apply a high pass filter with either Overlay or Soft Blend mode.
One final point, I find that images for web/monitor in my experience require a more toned down sharpening technique.
I also prepare images for print... (I'm old school and its not a 'photograph' if its not printed
) and sharpening tends to be a bit more aggressive if print is involved.
Hope this helps, but in all honesty, I'd suggest that you experiment, but keep it simple to start with until you are comfortable with any specific technique. Once you get a feel for the differences you can then start 'combining' their effects... Good Luck!