Yinan got it. The Cell CPU is a multicore processor having one Power Processing Element (which is like the single core of the average CPU, this one particularly loosely based on the IBM POWER architecture used in Mac computers until the switch to Intel) and eight co-processors or SPEs, which are just really simple cores designed to run a particular type of code extremely rapidly. Thus the Cell only truly shines when the programmer programs specifically programs for the Cell. A Cell processor also does not run x86 code, so it is not compatible with any x86 only OS (Certain Linux Distros such as YellowDog have distributions coded specifically for Cell so people can run Linux on the PS3).
The Cell was designed to bridge the gap between the out of order execution general purpose CPU (Intel / AMD CPUs) and the highly paralleled nature of the GPU (nVidia and AMD/ATI GPUs) by designing a general purpose CPU (the PPE) with 8 highly parallel co-processors called Synergistic Processing Elements, or SPEs.
That's not to say it isn't used in computing. The Cell blades are sold as co-processing elements that can connect to PCI-X, PCI-e x16 or Infiniband connections and run software programmed for them far faster than the standard Opteron or Xeon processors already in use in the server. Cell servers can also be bought under the Cell development partner, IBM.
Technically you *could* game, but the OS must be designed for Cell as well as the game. At that point you'd have a PS3 But the new PowerXCell 8i is being used in IBMs certain blade servers now, which is the improved Cell chip based on the 65nm architecture (it is NOT the Cell used in the PS3 at this time).