when you connect the camera.
No special software required for the Canon.
Have you tried opening Image Capture and then connecting the camera. It should appear in the Image Capture window, as you know.
P
On my Mac running Leopard 10.5, Image Capture has Preferences that allow me to choose an option that opens Image Capture when a USB digital camera is attached. That's gone on my new Mac with Snow Leopard. I never needed camera software to make this work, and unfortunately I have a Canon camera and Canon does not make drivers or software for Snow Leopard. So, how does one get Image Capture to open and download images from a digital camera? Did Apple dumb-down Image Capture like they did to iMovie?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic