If I stick PDFs on it, I can view it on all my computers and devices. This holds for both contracts and ebooks.
If I stick pictures in the public directory, I can quickly show them to people
If I stick zip files in the public directory, it's faster than uploading to an SSH site
If do photoshop/fireworks/balsamiq mockups work out of dropbox, it's on all the computers, and can be pulled up on an iPad in a customer location.
If I stick the scanner on one computer with the output directory in dropbox, I can connect the scanner to one of the desktops, then have it automagically copy over to my mac laptop when done.
I can just pass things over to my colleagues by shoving them in a folder. For project documentation where ever I am I have the latest copies.
Access via my phone means I can usually pick up things I have forgotten easily as well.
I do have almost all the rest of my data in the cloud - but for stuff that is local Dropbox is the next best thing
I could imagine the world 1000000 times better if everyone can fire up a shell and do something with that. Sadly it's not the case.
Being able to send files to people makes sense, but 9 times out of 10 e-mail does the job there just fine. I'm still not getting it, I guess :) Maybe my life is just too boring.
I also use it as a secondary backup for particularly important files (in addition to my physical backups)- it's replaced the "email myself a copy of the important presentation" process.
some people use it to sync their 1password database.
If my computer dies (which it has recently) all of my stuff is covered. Is there some area of content creation that I am just missing altogether? I guess I don't back up my photoshop or audio work I do occasionally on dropbox, but that's probably not it.