I access dropbox from my iPhone and iPad constantly as well, but I do so from GoodReader, where I download files, organize them, read them, password secure them, etc...
I've tried out the new "Photo's" feature - but I already have 100% intelligent photo syncing between my systems with Photostream - so I stopped the camera from syncing after about 5 minutes - my photos are already in my Camera Roll + PhotoStream, and therefore in my Aperture Library. I couldn't understand how, or why, I would want to use Dropbox to sync them again.
This is one of those extraordinarily rare times where I think Apple's Photostream, with shared photostreams, and Albums, both public and shared - actually provide the "Web/Internet" services that I want.
Anybody else find a use for the iOS client for Dropbox?