I "cut my teeth" on the Atari 2600 in the late 80s, but my absolute FAVORITE console and "era" of gaming, so to speak, was the Super Nintendo/mid-late 90's. Honorable mention goes to the PlayStation. Back in the day when "Squaresoft" was still a thing.
I started losing interest in gaming when I eventually got a Wii. My kids have roped me back in a little bit since pooling their money to buy a Switch, but I don't think anything will ever really compare to those games from the mid-late 90s. In fact, I still have my old consoles and games, and have been "making" my kids play those - and they tend to agree with me that there's something "special" about those older games.
Warms my old decrepit gamer-heart