Raspberry Pi as a universal platform

Sure, it was sponsored content vs. an actual story, but a thing that popped through my Facebook feed suggested using a Pi setup to download emulators.

Anyone done this? What model Pi? LOL what case for the Pi? How hard was finding workable USB controllers for the various systems? I see there are a decent handful of google hits on this, but I have no idea what I'm looking at.