Look a whole slew of FP arrays over the years have had niches here and there where they could get good utilization and therefore performance. But the niches were few and far between and the programming effort incredibly large such that like CELL after them, they are in the dustbin of history as the failures they were and are. It isn't good enough to be able to not suck on one or two things, you have to not suck on most things, and micromanaged architectures just don't do that.
Since 2005, we have seen Cell Fold@Home, decode & encode H.264 video in real-time, track motion for gaming, recognize speech, perform GPU functions (culling, lighting, postprocessing, AA), tackle scientific computing applications on RoadRunner, execute Air Force R&D apps, power the entire Blu-ray 2.0 stack (Java VM + 1080p main profile AVC video + TCP/IP with capacity to spare), perform financial modelling, hunt for oil fields, crack security keys including the root key for PKI infrastructure, bring up secure kernel for DRM, run assorted game logic including physics simulation, enable DVR + Cell HDTV @ 480Hz refresh rate, support Linux and even a web browser + Flash. It may not be able to do everything under the sun well, but for a media box, it's not bad.
Which CPU in 2005 can do the above at the same performance level, heat envelope and cost as Cell ?
The fundamental shortcoming of cell is the memory model and programming model. Those aren't things that will be overcome with technology. Comp and heat level in 2005? There were plenty of other failed architectures from then that did better when they talked about peak. As far as delivered? Cell is orders of magnitude WORSE than any duel core x86 from that era on a variety of workloads. Add in the increase in cores, AVX, etc. There is a reason CELL is dead, kaput, canceled, all development stopped.
Sure, but who says Cell 2 can't evolve to incorporate more modern programming model when it needs to ?
5 years later there are still a lot of workloads where CELL is far behind x360 in cpu performance even with all that time to work on programming tools, etc.
And there's a lot of workload where 360 and x86 falls way behind Cell.