All game consoles were great in the time at which they were at.
All the past games on them seemed good because of time we were at in our lives. Current generations of fans have new games and new consoles that they consider classic already. Games like Halo, Half life, Doom, Quake, etc...

Time moves on. So the greatest game console ever? Well, that would currently be the XBOX 360.