Well, then, have we got a deal for you. lets you choose which application your Mac launches, all depending on the camera that you plug in. For example, make iPhoto launch for your point-and-shoot digital camera, while Aperture opens for your DSLR and Image Capture opens when you connect your iPhone; you can also choose to have your Mac do nothing at all.
Even better, your images can be downloaded automatically, so you don't have to futz around with whatever application you choose--Cameras can even add photo metadata to Spotlight comments and delete the originals from your camera.
Cameras requires Mac OS X 10.4.11 or later and works with pretty much any photo device.