The holy trinity for me is SNES, PSX, PS2. I know this is massively colored by when you grew up and what you had access to, but nothing since has outshined these in terms of actual fun for me.
I’m inclined to agree, though I’d include the competing consoles of the era as well as the PC games available at the time. So roughly everything from 1990 to 2006.