For a really long look at the Cell processor, take a really long look at this article over at CoolTechZone. Part of the summary:

The problem with Cell is not the power because evidently it’s more than enough for regular day-to-day tasks, but it’s the willingness and acceptance of users, manufacturers and vendors to write code optimized for it. If they do, the results will be astonishingly realistic and only then will the true potential of the Cell be unleashed.

Link: CoolTechZone – Cell Microprocessor: An In-Depth Look at the Future