Apple didn't screw anyone. Even software developers are moving away from PowerPC like Adobe and most games now are for intel-only macs, are they screwing people over as well?.
Also the last proper PowerPC was sold well over three years ago, long enough really to support a dying CPU line. The main reason Apple is supporting intel only is so they could spend there time optimising for intel to make it faster for the current generation of Macs, I assume the majority of intel macs out there will be core 2 duo, so pretty much most people will be taking advantage of 64-bit Snow Leopard.
Coming from a user who still owns two PowerPC Macs
I agree with you, I have a 17" G4 Powerbook, and it is far from dinosaur status around my house. Just before SL landed I upgraded the RAM, and moved to Leopard and iLife 09 / iWork 09. It's like a new Mac again, and more than fast enough for anything I need to do on it.
But I did run across something strange the other day. A friend with a G5 iMac (running Tiger) wanted "upgrade advice" but only had a few hundred dollars to play with. I pointed him at more memory and upgrading the same way I did. After some deliberation, he thought to do the same thing. He upgraded the RAM and right there he said it felt like new again. So he went to the Apple store to purchase the Mac Box Set with Leopard, iLife and iWork. Guess what? They don't sell it anymore. They only sell the box set with Snow Leopard. Apparently, you can't purchase Leopard from Apple anymore. Now how stupid is that?
I'm sure he can find old versions of the Box set on amazon, or e-bay or somewhere, but come on, you can't purchase it from Apple? That seems pretty odd to me. Especially when there are many, many classes of machine that are still in service that cannot run Snow Leopard.