It was primarily the memory architecture that made the PS3 unique.
My understanding is that the largest difference is that some of the Cell cores had different opcodes that meant you could schedule some threads on some cores but not any thread on any core.
No cache they are just dumb processors. I find it funny they thought they can take ps2 vu0/vu1 and make it a processor.