My story: General hodgepodge of all the symptoms discussed by others, including -10810 error messages that can't be clicked away, unresponsive Finder/apps/Dock, no ability to open new apps, no ability to switch among apps using Cmd-Tab, ability to move app windows but not make them (or their menus) active, disappearing menu bar, dead Dock, and usually an inability to get out of the downward spiral without a hard reset (or, if lucky enough to have a responsive Terminal window, reboot -q).
I've tried Disk Utility, reinstallation to 10.6 and then to 10.6.1 and 10.6.2, deleting all sorts of caches and preferences such as all those mentioned on this thread (yep, I read it all), turning external drives on, leaving them off, enabling/disabling Time Machine, enabling/disabling Time Machine, cleaning caches and rebuilding Launch Services via Onyx, feeding the SuperDrive communion wafers, and, today, splurging on the $100 Disk Warrior and running all its file checks and directory rebuilding services.
All no good.
FWIW, for me the problem doesn't appear to involve external drives; even with those disconnected and the iMac restarted, I can always duplicate the problem. For me, it's 100% – and nearly immediately - replicable by starting Spotlight indexing. No Spotlight, no problems. So thanks to 10.6.x, I have a Mac with no Spotlight.
Also FWIW, when I reinstalled into 10.6, I had no problems even with Spotlight. Or, at least, for as long as I kept it running before upgrading to 10.6.2 - you see, I have this expensive new Magic Mouse that won't run on 10.6. So it's 10.6.x with no Spotlight, or 10.6 with no Magic Mouse.
(That's half guess, of course; I don't know for certain that the problem wouldn't eventually pop up on 10.6. Seems it has for some people.)
In any case, this is becoming a very time-consuming and expensive issue. A screw-up this bad is really a first for me, Mac-wise!