As stated in Dropbox FAQ:
Camera Upload tries to be smart about not uploading the same photos and videos more than once. It will not re-upload these files even if you move, rename, or delete them from the Camera Uploads folder.
So, how can I clear this "cache" and reupload all photos again after deletion?