I use Lightroom with the database and media on an external drive. That gets backed up to two other drives and one of these are kept offsite.
Downloading is made through Lightroom with an external CF reader. The reason for doing it through Lightroom and not manually in Finder is that I change filenames and add IPTC information and keywords when importing. Lightroom works well as a DAM solution, even if I miss Aperture sometimes. For me Lightroom is easier to use for basic edits and batch edits than Aperture, that's why I changed software even though the DAM part was better.
When lighting is difficult I use Colorchecker Passport to profile the light.
Sometimes Lightroom does not do what I want it to, even with the NIK plugins, and then I have to use NX2 if the RAW file just doesn't render well in ACR or CS6 if I have to do some masking to edit just a part of the picture.