the key solution being: "to turn this off for all cameras, open Image Capture, and go into it's preferences. there's a drop down box for what you want done when a camera is connected."
(Image Capture will be within your Applications folder, not far from iPhoto probably)