Last time we had this discussion (particularly with Tony), I recommended
Breezebrowser. I think it's a great piece of software, but Tony didn't like it because it was just another viewer. What he was looking for was something to replace the crappy Canon software you need just to get pics off the camera.
Well, since that discussion, the guy that develops BreezeBrowser has developed a downloader utility that supposedly works well. I haven't tried it myself, but you might consider checking it out:
http://www.breezebrowser.com/G1/Downloader/index.htm