All due respect Wilson, it's irrelevant whether I'm under-estimating or you're over-estimating. As I said, I'm not downplaying the issue, but it's only going to be dealt with when Apple hears from enough people (DIRECTLY) to warrant action.
If the problem is as serious as I bet it is, then Apple's already working on it, as they've been able to reproduce it in their labs. That said, I'm a small-time Mac consultant, with 100-plus clients, and I would bet about a quarter of those have moved to Snow Leopard. I'm the only one I know who has experienced the issue, and it was one time, never to return...
Again, don't get me wrong! I'm not an Apple apologist!! I, too, believe Snow Leopard to be far from the "performance and stability" upgrade we were told it was. I've had far too many weird little issues, though too many spinning beach balls is not one of them. Apple has some work to do to bring the situation around, and I'm simply writing to urge everyone to make concerted efforts to spread the word directly to Apple as much as possible.
I believe the vast majority of issues with SL have to do with legacy software. Since it's attempting to initiate the move to 64-bit, and begin the process of eliminating all PPC code altogether, the more old software you run that requires Rosetta, the more issues you're going to have. This is one of those painful transition periods that will eventually lead to much better times. It's just painful as heck in the interim!
Thanks for posting, and hopefully we'll start seeing some improvement from Apple very soon. I sure hope so!