I would say you have answered most of your own questions concerning the current state of emulators and whatnot on this device.

Saying that the N64 emulator is superb for the games that do work and although things have stalled at the moment we live in hope of future updates. Things look bleak on the PSX front and GBA developement seems to have been abandoned. This is only what I have gathered from these threads though, I dare say the devs know more.

Control on the faster games (Mario etc) is horrible via the keyboard but there is a Game gripper (mine is in the post) available and the accelerometer on the N64 emu is very good.........esp on Mario kart