Doesn't this require you to launch the DB app to upload new photos? I don't think third-party apps can be automatically invoked when you take a picture.
You can also set it to upload your photos when you plug-in your device. The dropbox client accesses the files on the device as if it was a camera.
Oh right. Too bad I never plug my phone into my computer.