The first good console for me was the NES. I enjoyed the Atari 2600, but only because it was the best at that time. But I can still enjoy a good NES game.
There aren’t many games on the Atari 2600 that I would still consider fun today. Maybe not necessarily because of graphics, but the graphics were pretty bad too.
It’s interesting that most modern retro-style games seem to keep a higher color and resolution than even the last great 2D generation (SNES/Genesis).
There are some games that hold try to that generation’s specs, though, but I don’t see many go as far back as the NES (and especially not the 2600).
There’s a small niche of people that make/have made modern NES games (actual cartridges for the actual console or remakes of the console), and those that play them, but I’m not aware of any super popular ones. If anybody’s aware of any, let me know!