The dropbox app on my iPhone does indeed seem to have a feature that allows it to auto-upload photos to dropbox. I don't personally use it but it looks like it'd do what you want.
_________________________
Tony Fabris