Photo Sync is an awesome app. You can sync between your iPhone, ipad, and computer. It is not a free app but the app for the computer is free once you buy it for the mobile device. There is no limit on the number of photos you can transfer and you just need wifi. I think it is about $.99.
Now that we have iOS5 which includes iCloud and the photo streaming I use that to view and copy photos between my computer, iPhone and iPad.
I agree that PhotoSync works pretty well for videos
Update: after updating this post the other day, I went back to trying Photo Sync and it features again. As others have mentioned it really is the best way to move items to other iOS devices and the computer.. Much better control over iCloud and Photo streaming. Check it out if you have not used it
PhotoSync - wirelessly transfers your photos and videos
Company: touchbyte GmbH
Category: Photo & Video
Updated: Jan 27, 2012