Its generally best to do as much of the color and density correction in the scanning software as practical.
Personally, I use an EPSON v700 and use EPSON's own EPSONScan software most of the time (I also have SilverFast). I've found the auto exposure, auto color, and "Color Restoration" (probably much like Canon's "Fading" correction) quite reliable, though I do often make manual adjustments, particularily with poor originals.
Dust removal is a different issue. My scanner and software both support Digital ICE and EPSON's own dust reduction method. Digital ICE works well on most, but not all, films. EPSON's works on all media, even prints, but is often either less effective or more prone to generating odd artifacts. Both can be rather slow working I often find manual dust removal preferable to the artifacts generated in auto dust removal.
Scanning prints at 600ppi is somewhat overkill. No commercial print papers can hold detail that fine. Generally 300ppi will capture all of the detail in the print. The higher scanning resolution only improves the resolution of dust, tears, and scratches. If a print will ultimately be enlarged, then its valuable to scan at higher resolution since the image will needed to be upsampled otherwise.
For film, I would generally suggest a higher scanning resolution. 2000ppi is fine for large format sheet film and antique large roll film where the camera's lenses were marginal and grain is rather large. With modern high quality medium format, I would suggest 3200ppi and with 35mm something between 3200ppi and 4800ppi if you are needing to capture all of the detail in the image. A lower scanning resolution would be fine, though, if your use will only be for small snapshot sized prints or for web display.