I use the "Neat Image" plugin for Photoshop and then either create a new profile from my film/slides, or I load a pre-made profile for my Nikon D1. That takes care of a lot of noise. NoiseNinja is another one that is available. Both have limited trials. They only run like $75 to buy for the pro version, less for non-pro versions.
My Nikon V ED scanner also has ICE, ROC, GEM and DEE on it. So those can help with noise and imperfections.
Another trick I use is a variation on this guide:
http://www.glamour1.com/tips/articles/snapshots.php
With snapshots, you can do a lot of things that would have otherwise been difficult or downright impossible. That and the clone tool are how I did some of the skin and blemish correction.
For the eyes, I just add a new layer, drop in close with a brush, pick a color I want, and then blend. For this one, it was soft something (forget exact name) and then it was 30% or so. Have to be REALLY careful with adding new colors, easy to mess up.
The image here is also from Fuji slidefilm, so I have a lot to work with, in terms of clarity and exposure.
I could actully do MUCH better, this was just a quickie to show CPS members what all you can do in Photoshop. Photos are no different than DVD menus or DVD case artwork. If an image is not perfect, fix it, make it look nice for that menu or case. Not hard to do, just spend time learning.
I learned a lot of this stuff from some pretty well-known photographers, first hand, either from them personally, through correspondence, or by attending workshops they put on. In 2004, I had to quit taking photos for various reasons, costs being one of them. I decided about a week ago that I've been away from the camera too long, and need to pick it up again, and try to make contact with those from my past.
Unfortunately, one of my teachers died last year. I just found out this morning, while trying to hunt down a few people. He was actually pretty well-known, and came from a family of well-known artist.