Hi Neil - I've been a CS2/CS3 user for about two years now and have been using ACR.
For a short time I did use Canon's DPP... it was ok, and a lot of folks do like it. But for some reason ACR seemed to have more of the features and layout that I like to work with (resonates with my old darkroom days) so I've stuck with it. Most of my work is wedding, social event, and then a lot of urban landscape:
http://www.pbase.com/sapearl/cleveland_flats
Here's my basic workflow after doing a wedding or some other large shoot:
I transfer all the files to the PC using a small inexpensive USB connected Sandisk card reader. These go straight to a separate 250GB scratch drive. I use ACR for the RAW file transfer.
For a wedding, I will first adjust WB, again with ACR's eyedropper tool, and batch apply the WB color temp to similar groups of photos. Then there is general global exposure adjustment, brightness/shadow tweaking, and finally perhaps some highlight recovery or shadow fill. Note the these last two are new with CS3. I think they are fantastic additions Neil. I've been able to nicely recover some blown pixels that would have previously been more difficult.
Once I've made ALL of these "global" adjustments, I will make sure the files are in the proper client viewing order, rename them to some sort of logical/sequential file name convention, and then start the JPG conversion process using PS. I will typically use Quality Level 10 which will give me files 2.5 to about 4.5MB in size.... roughly.
Everything gets backed up to another hard drive, as well as burned to two sets of DVD's for safe keeping. Hope this helps Neil - let me know if you have any more questions.... glad to help
. - Stu