NES: 8-bit 6502 with integrated sound hardwareay 1.79Mhz
SMS: 8-bit Z80 at 3.6mhz
SNES: 16-bit 65c816 hack of the 8-bit 6502 running at 1.79, 2.7. or 3.6Mhz
Genesis: 16-bit 68000 (SegaCD: same, but 12Mhz, rather than 8, 32x: two 32-bit SH2 CPUs at 25Mhz)
Playstation: 32-bit MIPS clone CPU (R3000A) at 33Mhz
N64: 64-bit MIPS CPU (R4300i, designed with SGI) at 94Mhz
Saturn: dual 32-bit SH2 CPUs running at 27Mhz
Dreamcast: 32-bit SH4 CPU running at 200Mhz
GameCube: 32-bit PowerPC G3 based CPU running at 485Mhz
Xbox: 32-bit Intel Celeron running at 733Mhz
PS2: some crazy MIPS knock off that they call the "Emotion Engine" running at 300Mhz
Xbox 360: Triple core 64-bit PowerPC G5 based CPU each core running at 3.2Ghz
PS3: some crazy "Cell" crap with the main core being a 3.2Ghz PowerPC G5 based chip, also there are 7 vector processing units on the chip which are supposed to help with all of the graphic rendering.
That's pretty much all the consoles from history that matter, and I think it answers the question.
All from memory, though I did check my facts. :)
Also moved to "General Gaming" where it belongs...
