My workflow is as follows:
So, I shoot RAW on a CF card, and video and JPG on SD card. I use an iPad to review the JPGs which are processed a lot by the automatic settings so I have a vague idea of what the images might become in post.
1 ) card in card reader, and copy to \raw import\ directory on my 1st external drive.
I keep the same folder naming as the camera uses to just put 10k pictures in a folder and move to the next one. No sorting whatsoever on the disk.
2 ) card still in card reader I move the files to \raw import\ directory on 2nd external drive.
Both drives are chain locked to the concrete wall. My mac is not. So thieves wil take the mac, and not the drives.
3) import all in lightroom and create a collection of the event I shot. If its a gigapixel or virtual tour it lands in that sub collection.
4) flag and reject run of the pictures. Just quickly going over whats a keeper and whats not.
5 ) select "flagged" and crop all pictures to a nice composition. If I feel I don't have enough pictures in the flagged category I might look trough non flagged non rejected to upgrade the rating on a few more.
6 ) do color, contrast and sharpness magic
7 ) export to one of my many export profiles. I make a profile every time my existing profiles don't cover my needs.
8 ) distribute the pictures in whatever way applicable. Normally I upload to a /customers/ directory in a protected zip file on my website.
Backups are done from my 1st external drive to an old Dell 2950 in the shed (yes I dug a CAT7 UTP trough the lawn. Wife wasn't too hapy about the trench trough her Tagetes). I configured that to wake-on-lan and auto power off so it wont eat too much power wile on. Its a dual XEON machine I also use to render panoramas, and only cost me 96 euros at a proper shop with warrantee.
If anybody is interested I'll do a separate gigapixel workflow