Mostly used to watch movies to be honest
The PS3 contain a Cell processor and all the details about coding for it can be found on the page about it.
Nvidia RSX that have 256 MB GDDR3 memory. Accessed by the PPU and SPUs with DMA.
The Creation of Killzone 3 - 2012
SPU-Based Deferred Shading in BATTLEFIELD 3 for Playstation 3 - 2011
Parallelized Light Pre-Pass Rendering with the Cell Broadband Engine - 2009
Battle-Tested Deferred Rendering on PS3, Xbox 360 and PC - 2009
SPU Assisted Rendering - 2009
Crowd Simulation on PS3 - 2006
256 MB system ram used by the PPU and accessible by the SPUs with DMA.
Sixaxis and later DualShock 3. Later the PlayStation Move was added as a motion-sensing game controller.
The PlayStation 3’s SPUs in the Real World: A Killzone 2 Case Study - 2009
PlayStation 3 Architecture