Well, obviously it's not a real SNES, but it looks a lot like the US version of the Super Nintendo, and it plays just about every game you can imagine. Super Nintendo games, Mega Drive games, NES games, Atari games. It was created by Reddit user Angryspec as a little personal project and took six months to make.
It uses a Raspberry Pi model B as its main processor, but plenty of actual original SNES parts remain part of the design. According to Angryspec, he bought a couple of controllers and replaced certain buttons with SNES controller originals, giving him the look of a brand new controller consistent with his design, while retaining the unique feel of the SNES controller.
It uses ROMs as you might expect and a Dlink four port USB hub for the controllers -- so that four player Super Bomberman can be played (good call). There is a HDMI port on the back.
Seriously, if you were to travel back in time and give this thing to me as an 11 year old, I think I might have just spontaneously combusted from the sheer excitement. Today? I am awash with a weird nostalgia and I just want one.
Chrono Trigger. Good choice.
You can find out more about how it was put together here.