I open RAW files in Adobe Camera RAW (ACR). I set the sharpening slider to 67 and adjust from there, although usually not much. Under the sharpening slider is a masking slider. If you hold down the ALT key (Mac: Option Key) as you move that slider the image turns black with white showing the areas that will receive sharpening. I adjust it so just the outlines of objects get sharpened. If I need to use NR, the slider is also on that tab. I rarely go past 40 on that and usually I'm well below 40. Shooting to the right gives you more signal-to-noise and allows you to then reduce exposure in ACR, which cleans up a lot of noise.

In Photoshop I duplicate the image layer, change the blend mode of the duplicated layer to Soft Light and then apply a ~10 pixel High Pass filter. I'll mask that layer and paint in just the areas I want sharpened. (Technically it's not sharpening, it's just raising micro-contrast.) This works well for critters and architecture. It *does not* work well for portraits unless you like seeing every detail of a person's skin.