Anandtech has a nice writeup of the upcomming Playstation 3 and XBOX 360 hardware strenghts. Apparently they are nowhere near as powerfull and PC crushing as stated previously. Developers will most likely use only one core rather then the multiple cores in these devices.
Really interesting read.
Link
The other point that has been made is that even if you can offload some of the physics calculations to the SPE array, the Cellâs PPE ends up being a pretty big bottleneck thanks to its overall lackluster performance. Itâs akin to having an extremely fast GPU but without a fast CPU to pair it up with.
Right now, from what weâve heard, the real-world performance of the Xenon CPU is about twice that of the 733MHz processor in the first Xbox. Considering that this CPU is supposed to power the Xbox 360 for the next 4 - 5 years, itâs nothing short of disappointing. To put it in perspective, floating point multiplies are apparently 1/3 as fast on Xenon as on a Pentium 4.
The most ironic bit of it all is that according to developers, if either manufacturer had decided to use an Athlon 64 or a Pentium D in their next-gen console, they would be significantly ahead of the competition in terms of CPU performance.
Really interesting read.
Link