i had an NES emulator on my DS as a kid and i really only remember Super Mario Bros 3 and puzzle games having any sort of modern appeal. there's a lot of games that are fun but they've just aged and while they are still fun they are just old. river city ransom is the big one i can think of. that game would have been mind blowing if i played it in 1984 but like dawg i played it over summer at my grandparents house on my DS in like 2006 i truly dont know if it would hold my attention today
A lot of Nintendo's later titles like Mario 3, Kirby's Adventure and Star Tropics are great. Mario 2 is a fun game to revisit.
The black box games have all aged terribly outside Super Mario Bros. If you're playing them in 2026, you're playing them for the wave of nostalgia you get from the title screen and music that dissipates ten minutes in. Even with Super Mario Bros. I can blow through all 32-levels in an hour or so at this point, and there's little point to revisiting it for more than an hour or so every few years.
A lot of third party games that I really liked in the early 90s like Final Fantasy and Dragon Warrior have aged terribly and have better ports on other consoles. There are some OK arcade ports, but why would you play them on NES when you could play them for SNES or Genesis or even emulate the actual arcade game?
Mega Man 2-6 is great, Castlevania 1 & 3 are great, Turtles 2 & 3 are great, Crystalis is great, Faxanadu is great, GI Joe is great, a handful of Disney games made by Capcom are great. How many of those are just games I'm nostalgic for and how many are actually worth playing today as someone who didn't play them in the late 80s/early 90s? No idea!
I'm sure there are some I'm missing, but I'm struggling to think of more.
Gun to my head, I might only be able to think of 30 worth playing for GBA too, but as someone said, GBA was really only the main handheld for a couple years.