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.