This isn't even an Apple specific use-case.
There's real opportunity for Dropbox (if they stopped syncing everything everywhere), or Flickr (if they suddenly made really great native clients) to sew this up.
Google probably hasn't a chance in hell given the neglect that they're showing to Picasa.