The cell CPU was something like a dual core with 6 additional, specialised stream processors. I think the closest analogue might be a a CPU with a few cuda cores on the die?
It didn't work too well from my understanding, difficult to develop anything that could make use of those streaming cores that was worth it over a traditional multicore chip with more cores.
Useful for scientific community though.
If anyone knows what the spe cores were used for in games, I'd be very interested to know.