Fortunately, there's a simple way to turn this off. Open the Image Capture application (it should be in /Applications/Image Capture) and select Preferences from the Image Capture menu. In the "When a camera is connected, open:" pop-up menu, select "No application" if you don't want it to do anything, or "Other" to select something like iView Pro. Quit Image Capture and the frustration will end