@sean I know of that emulator one for Pi, but its only ROMS not full on steam or anything.
But honestly you dont need a distro for that. Use whatever distro you want and just set it up to boot direct to steam, problem solved. If you really want it to feel like a locked down console then dont boot a WM at all just raw xwindows with STEAM in full screen mode.