Two veeeery nice Raspberry Pi handheld console projects. Inspiring stuff indeed!
Raspberry Pi – Atari Lynx
Raspberry Pi – Nintendo Gameboy
I thought about doing something like myself with an old Gameboy case I have. Nothing as exciting or technical as this though, I was just going to use it to house an external 2.5″ harddrive.