How to build this particular automated workflow

I've tried Automator, but I can't figure out how to get it to do what I want. And maybe I can't do it (or need something other than Automator).

Here's what I'm trying to accomplish:

1. I plug in a camera to my computer (MacMini server in this case).
2. iPhoto automatically launches, downloads the pictures, deletes them from the camera, and (if possible) unmounts the camera.
3. Have an alert or system sound play when it's all done.

I don't want to have to do any other inputs. This computer is headless, so I want other employees to be able to attach the camera and have this all happen without them doing anything.

Any ideas? Most of what I found in Automator requires some kind of input from the user.