To give furher details on workflow, I have one system that is used with slides and negatives and another strictly for prints (the print system has 4 filtered copy lights @ a 45 degree angle). For the former, the negative or slide is laid on top of a color-balanced daylight light box, with even illumination. A sheet of plate glass is laid on top, to hold all flat. I get fantastic results from black & white negatives, slides and prints. It's just the color negatives that are problematic. White balance is not a problem.
In addition to the DSLR systems, I also have a Kodak CREO Eversmart 11 flatbed scanner. When I have larger jobs, I use this, as it can handle 40 35mm slides at a time. Or, it can handle several strips (6 or 7 negs. each) of negatives. This scanner can be set to "positive" for slides or "35mm negatives (productive)" for negatives. I get fantastic results from black & white negatives and slides. Again, it's just the color negatives that are problematic. White balance is not a problem.
I will have a look at Color Perfect and VueScan - just haven't had the opportunity yet.
The results I get from the DSLR system and the CREO scanner (which uses OXygen scan 2.6.4 software) are the same. So, it doesn't seem like the problem lies with the lighting, scanner type, software or operator. (there are 2 people using both systems)
I really feel that I lack understanding about how to deal with color negatives in Photoshop, so that is my real question. I will take the suggestion that jslabovitz gave about a specific way to do this "by hand".
Thanks much