Cam2pc has been working brilliantly for many years, and I've yet to see anything that comes even close to what cam2pc does, especially in terms of its fantastic download-and-rename capabilities. (I do the rest in Picasa.)
Unfortunately, cam2pc is no longer maintained. I've seen mentions of IDdownloader and IDimager and these are allegedly "at least" as good as cam2pc, or even better. But there's no trial version, and I hesitate to shell out $30 (IDdownloader) or even $70 (IDimager) without a chance to try it out first.
Can someone provide more information? Reviews? Feedback?