Automaticly and seamlessly sync iPhone photos as soon as they're taken (over the air)
I too have tried to find something to do this, with little success. Documenting what people have tried may be helpful, so here's my list:


Cinq -- offers to sync with iPhoto on the Mac, or to the filesystem on a Mac or PC; only works for photos taken within Cinq
DropPhox -- syncs with Dropbox; only works for photos taken within DropPhox
Eye-Fi -- syncs to local machine, and lots of online services (Picasa and Flickr but not Dropbox); free (although nags to upgrade); will sync photos that were taken with any camera app on the iPhone; requires (as far as i can see) an Eye-Fi card to set up an account and get it working


All of these have their drawbacks; would love to find the app that can upload all photos automatically.