I have iPhoto auto-connect turned off.
I just wait a few seconds for my D300 to show up in Finder, drill down into it, and copy/paste the images where I want them.
Maybe your Canon doesn't have an "I'm a disk drive" mode, but if it does -- that's your easiest solution.