Photos directly to dropbox, discarding local copies automatically
I believe what you're referring to is covered by http://www.uploadcamapp.com/

They accept upload to Google Drive and Dropbox. Sadly, as of writing this, not OneDrive/365

I also don't know what happens if the service is down / no internet (does it sync later etc)