It was very experimental, that’s really the reason Sony went with it and it was at the genesis of multi threaded processing, so the jury was still out on which way things would go.
Your description of it is a little wrong though, it wasn’t multiple CPUs, at least not gore would be traditionally thought. It was a single dual core CPU, with 6 “supporting cores” so not full on CPUs. Kind of like an early stab at octocore processors when dual core was becoming popular and quad core was still being developed.
I remember that the ability to boot Linux was a big deal too and a university racked 8 PS3s together into basically a 64 core super computer. I’m actually sad that didn’t go further, the raw computing power was there, we just didn’t really know what to do with it besides experiment.
Honestly I think someone had a major breakthrough in multi-core single-unit processors shortly after the PS3 launch that killed this. Cell was just a more expensive way to get true multi threaded processing and a couple years later it was cheaper to buy a 32 core processor.
Maybe in a different timeline we’re all running Cell processors in our daily lives.
Were you using dish soap like what gets bubbly in your sink? Or dishwasher detergent which does not get bubbly. Dishwasher detergent will probably be fine in a washing machine, same as your dish washer because it’s not supposed to foam up. But the soap you use in your sink will have terrible consequences in either a dish washer or washing machine.