Sharpening can be a rather complex subject. There are books dedicated just to sharpening.
I'd suggest that you keep doing lots of reading & viewing on the Adobe site network.
For a long time, I used USM (un sharp mask) in Photoshop. (Photoshop CS, which doesn't have Smart Sharpen).
I would also use a technique often called High Pass sharpening. I believe it uses the exact same sharpening technique as USM, but because it was layer based, was a little easier to customize.
Now, with a newer version of PS, I will use smart sharpen (if I do any sharpening in PS). Although, I couldn't tell you the technical difference between SS and USM.
But what I do now...is mostly just sharpen via Lightroom. The sharpening inside LR comes from a company/program called Pixel Genius / Photokit Sharpener. Again, I couldn't explain the technicalities of it...I just use it.
But, the key to using sharpening, is to realize that different images will require different amounts (or even techniques) of sharpening. So it's not so much about finding setting/techniques that work, and then always using them....it's about finding what what works for at particular image. To that extent, when i'm really into heavily editing an image, I'll apply selective sharpening, so different areas may get different amounts of sharpening.
And lastly, note that 'sharpening' isn't about taking photos that are blurry and fixing them. For example, unsharp won't correct for missed focus or motion blur (although, it can disguise them a bit). What sharpening actually does, is increase local contrast.
One reason why sharpening is such a big deal in digital photography, is that most digital cameras have an anti aliasing filter in front of the sensor. This is to prevent moire from forming when photographing something that has a pattern to it. Unfortunately, a result of the filter is that it robs some possible sharpness. A few cameras, the Leica D9 for example, doesn't have an AA filter, and is thus capable of incredibly sharp images. You just have to watch out for moire. (Lightroom 4 is coming out soon (currently beta), has an moire correcting brush tool).