So something like:
1 - always back up to primary backup locations in full. 2 - back up to primary backup locations if it's not too much trouble (some sort of configurable threshold for space) 3 - like 2, but a lower threshold 4 - only back up to secondary backup 5 - do not back up.
I know that there's a lot of configuration that would have to go into this, but I think as data becomes a bigger part of our lives, we need to have a more intentional attitude towards how we store our data, and not just 'let the computer back it up.' Until movies are as easy to store as text is currently, there will always be tradeoffs that we will want to think about.
Having said that, the latest beta does allow you to choose to only sync some of the folders. So you can, for example, install Dropbox on your work computer, and choose not to sync your mp3s to it, etc. This should solve a lot of the use cases you have.
The only thing really missing, for me, is the ability to exclude specific files/folders from the Dropbox folder (like, for example, per-computer configuration files). I assume they'll allow that at some point, but for now I have to work my way around it. Still worth it though!
I keep all my important files in there (my mp3 collection, projects, documents, etc.). I have Dropbox set up on 3 machines (main machine, family computer and my laptop), so I get automatic syncing of all these files, plus backups of all the files on 3 computers, plus access to all these files in the cloud.
As far as I'm concerned, it's a revolution in how I work. Dropbox is now my guardian angel, silently backing up everything I do.
The only problem with this arrangement is that 50gb is too small for all my files (videos, mostly), and even their 100gb offering is too small for that. I expect this to change in the near future.