The Kodaks do a really good job of doing this. You can set up the preferences before starting up and then all you have to do is put the camera on the docking station and push one button. That's one of the major reasons why I had my mother buy a Kodak.
I would like to take a picture, dock the camera and have the picture copied to a target folder (always the same folder) and deleted from the camera. This should be silent (no dialog boxes or user interface). Anybody got an idea which camera / dock I should try?