Syncomatic is a pretty cool solution for updating your iPhoto or Aperture library with the latest images and movies from your iPhone.
The US$2.00 app is not the only app that syncs photos but it does do this in the background. To get things started, download a small companion app to your Mac. When launched, it puts an icon in your menubar. Click it to choose a destination for your photos (iPhoto, Aperture, or just a folder).
Once that's done, each photo added to your iPhone's camera roll will be instantly recognized by the Mac app. You can see what is synced and what syncs are in progress.
The sync works over Wi-Fi, not the 3G network. iOS5 will have something similar