Agree with most N64 games, but Mario Kart plays superbly. This is awesome.
I can't comment if this is the most 'powerful feature rich Pi out there' as there are other OS's that let you use the Pi as a network media library (pretty cool!) or even a unbranded Alexa type Pi too. Just search online for different Pi uses. For RetroPi you'll need a video game controller and game USB cable (not a USB charger cable, as I made this mistake -I couldn't tell the difference just by looking), a micro SD card and a USB memory stick to transfer between PC and retroPie. All instructions online. Google is your friend.
It does not run N64 well enough. Much better with 16bit classics to be honest.
Only if you're running stretch
Me too just found out about pie hole! Very impressed