I absolutely suck at multiplayer, but it really is a fun game. I liked how its campaign mode teaches you history too. It got two remasters, and both are quite good in their own way. 2013 has visuals similar to the originals, and Definitive has its visuals vastly improved but kept the gameplay same.
As for consoles, Chrono Trigger for SNES is the most remarkable game I can think of. It takes time travel very well, I was honestly surprised how such a game was made at that era.
If you want a more casual game, Puyo Puyo for Genesis could do well. It could be hard when you first get into it. The games back then were written to be more difficult to get more playtime out of games; and the AI can easily catch you off guard with big chains.
(Its english counterpart for Mega Drive is called Dr. Robotnik's Mean Bean Machine, but the game is easily understood as it is already.)
You should definitely check out Project Celeste. It's an opensource revamp of AOE-Online with great single player campaigns and multiplayer mode. They are constantly adding content and campaigns to the game.
These are made for X86, so I'm not sure they technically count as "old games", but I've had a blast with recompiled+ported versions of TLoZ:OoT and Perfect Dark.
Ship Of Harkinian in particular adds so many features and improvements, that I'm not sure I would enjoy the original OoT played on an actual N64.
I tried playing Perfect Dark on N64 again during the pandemic. Single player was great, multiplayer runs at like 12 fps and I have no idea how I ever played it as a kid.
Not a childhood game, but the Japan-only SNES strategy RPG Fire Emblem: Genealogy of the Holy War is a great handheld emulator game! There's English patches for it.
Some random games from the mid 90s and earlier that I enjoyed when I was younger:
PS1: Final Fantasy Tactics, Final Fantasy 9, Lego Racing
SNES: Final Fantasy 4, Super Mario World
GBA (not of this era, but they'll probably run on your Anbernic): Fire Emblem (any of the GBA games, but Blazing Blade aka just Fire Emblem is a great starting point), Metroid Fusion
The biggest part of my childhood was Shadow Man. It was the first game I ever played that built a big world to explore with excellent narration and a good sense of progress. It felt rewarding to finally play all the way through to the end after many months. Some of the levels and music gave me nightmares as a child, but it was worth it.
I enjoyed a lot of story-driven games since then, but this one will always have a special place in my heart. It's so cool that NightDive remastered it recently.
Somehow my tastes stagnated and ossified so I mostly only play my childhood games. That said those that stood up the most are
Super Smash Bros Melee
Super Mario 64
Wave race 64
1080 Snowboarding
Rise of Nations
Those 5 games have cumulatively, for better or for worse, consumed a pretty sizable chunk of my lifespan. Sounds depressing to think of it that way, but then they did such a good job of being fun that I continue to enjoy that time so you got to hand it to them, they're hella good games.
I played Paper Mario for the N64 and had a blast, super good game that I couldn't put down. Nice to know there are N64 games I've never played that still hold up