Why did Sony do it?
Well for the architecture of the PS3, remember they laid down their path in 2002 when pretty much every major architecture was single threaded and they thought that the Cell style architecture was an answer to two issues which are/were coming up for future computers. They saw that the forward rendering GPU architectures were going to run up against a bandwidth wall, and that single threaded architecures were going the way of the dinosaur.
The problem they have is that in hindsight pretty much every completely new architecture thats been released has failed. They failed to get developer support for their programming model and other more standard architectures quite simply outpaced the level of investment they could produce in support of their own architecture. The itanium architecure is failing, larrabee has been cancelled and the standard X86/GPU architectures with their massive investment soldier on and left their Cell in the dust. So whilst the Cell processor is a failure, it did make sense when it was first proposed in 2002 and it probably was a pretty good guess, its just simply wide of the mark.
The other problem was that GPUs have not hit the bandwidth wall as fast as was predicted. The Cell would have been a very good architecture if it wasn't for the continued bandwidth scaling of the forward rendering GPU architectures. The wall is coming, the physical limit for a copper pin is 10Gbps theoretically and the fastest GDDR5 can achieve 7Gbps IIRC. However that wall is pretty close at hand as once the compute levels in GPUs double again the maximum throughput that can be achieved through a GDDR5 interface is something like 200GB per second on a 256bit bus (guesstimate) which is only about 1/3rd more than the RV870 can manage.
The problem with their playstation business is that they were never called out on their mistakes last generation so they happily repeated them. The PS2 architecture was not the best architecture released last generation for performance per $$$ or performance per mm^2, that crown actually went to the Gamecube which used the POWER architecture which was cheaper, faster and easier to develop for than the PS2. This generation the crown for best performance per $$$ went to Microsoft with their Xbox 360 general purpose architecture which was both straight forward and high performance.
Tease.









