Having watched the microsoft and sony conferences and bits of the Nintendo one, the PS3 looks pretty amazing. The Nvidia section explains why too. Even if the Killzone bit was pre rendered, it seems like it would be entirely possible.
Xbox360 is in trouble, unless the PS3 goes for a high price...
For all the hints, Nintendo didn't really show anything yet...
Cheers,
Ben