There are dozens of consoles out there. Compiling a list of
every game for each system is impossible. The NES and PS2 have over a thousand games for their systems (NES US only is still over 700). Even a top 100 is a Herculean task. Some consoles/handhelds don't even have 100 games for them. Specificity is key here if you want good recommendations.
My suggestion is to just look up "best games for [console]" either here, other video game forums, or Google, too.
Some favorites I've used before include
Retro Sanctuary and vBender, though registration is currently closed there.
Alternatively, you can Google the oh-so-many "100/500/1000 best/top video games you must play of all time/worth playing today" and thumb through those lists.
Welcome to the club, but now digging through this all is the fun part.