FYI, retro means something new with inspiration from the past. The word you’re looking for is vintage.
Setting that aside, it’s gotta be the SNES. The games from that generation have aged far more gracefully than the early 3d games of the fifth and sixth generation consoles.
In german this differentiation is only valid for furniture (and sometimes clothing), everything else is always just Retro. 😮💨 People are unwilling to change their minds on that. I had that discussion often enough to give up and just accept it. Sometimes neo-retro is used for inspired new stuff, seems to be easier to create new words the to use the correct ones it seems. 😫
Super Nintendo, or SNES. The Mario and Zelda games were great, and so was Mario Kart, but there were loads of great third party games too, like Castlevania and Super Probotector (Contra?).
Xbox 360 if that’s to young then prehaps the PS2 or gameboy