A desktop app that lets you upload photos and videos.
Open-source tool for automatically uploading images to Flickr.
Aperture supports the use of tethered cameras via a hot-folder import mechanism