Complete Dropbox implementation for Android I'm looking for a method to retrieve all my files from my Dropbox account and download them to my SD card. 

This should download everything with no user intervention. There are a couple of Dropbox applications around but none of them have the ability to download everything and even worse most seem to work incorrectly on huge files skipping the last part or simply not working.
Titanium Media Sync offers continuous sync from SD Card to DropBox, but not the other way... the way I do it is setup rsync jobs with tasker and rsyncbackup... (requires your DropBox to be automatically kept in sync on a desktop pc somewhere, running an ssh server). The following should get you up and running:
Step 1: DropBox remote.
First, setup DropBox on a computer somewhere running an ssh server, so you can copy files from it over ssh (with rsync), and make sure it’s setup with private key encryption with an agent so you don’t need to enter passphrases/passwords every time
Step 2: RSync from remote to phone
Then, get rsync4android (market link)
That lets you setup rsync jobs from a remote server to your phone (and vice versa… I use it for this, but also for backing up my photos to my PC automatically every night)
Then create an rsync job to download a particular folder from your remote DropBox on your PC into the DropBox folder on your sd card.
Step 3: scheduled automatic rsync jobs
Get tasker (which lets you schedule jobs to happen on a large number of triggers, including time) (market link)
Create a tasker job to fire off your new rsync job to keep your dropbox folder up to date.
Step 4: Enjoy
Like I say, it’s a bit around the houses, but seems to do the job
I've also posted a copy of these instructions on my blog.