To answer all your questions:
Conker's Bad Fur Day: Doesn't run.
Paper Mario: Runs, but don't expect perfection. Flickering isn't too big of a deal anymore (although it does happen occasionally), most of the problems with this game is that almost everyone looks like a pale square or a shadow, depending on where they stand. Not a game killer, but can be very annoying.
Banjo-Kazooie: Runs pretty well if your willing to overclock a lot. It starts to really chug when you get to world 2, but it's been running up to the point I'm at (World 3).
Banjo-Tooie: I haven't tried this with the newest version, but with the last version, the game would crash during the first cutscene.
All the Spyro and Crash games: I have tried Spyro 1 and 2, and both run great. I wouldn't be surprised if the third ran also. Crash 2 and 3 run, but Crash Team Racing hangs (Apparently there's a solution to this involving the BIOs, but I've already tried it and it didn't work.) I haven't tried Crash Bash, but it's safe to assume it runs too, since PSXreARMed supports the vast majority of the PS1's library.
Super Mario RPG - Legend Of The 7 Stars: Runs flawlessly, as far as I can tell.
Zelda - Ocarina Of Time: Does run, but it's a bit choppy and has some graphical issues. Last I heard, The game crashes at a certain temple, making it impossible to progress beyond that.
Majora's Mask: Hangs after entering the second doorway after the first cutscene.
GB and GBC Emulation: There is a few good emulators available for these, and pretty much all of them work really well. The only difference is what interface you like (And sometimes configurations, too).
GBA Emulation: Not perfect, but still really good. It's sorta like PSXreARMed, it runs a lot of games, but it has a select few that don't run so well. Mario & Luigi and Kingdom Hearts: Chain Of Memories are examples of games that don't work, but pretty much everything else I've thrown at it (which is about 2 dozen games) Do.
NES: Pretty much perfect. I've only had 1 or 2 games not run on them (And I think it might be because they're bad dumps
)
SNES: Again, pretty much perfect. Star Fox, Star Fox 2 and Stunt Race FX don't run, but pretty much everything else does.
SEGA: Thanks to Notaz and his emu Picodrive, SEGA systems are pretty much covered. Genesis games are emulated flawlessly. Even Virtua Racing works! I've never had a Genesis game not work. Master System games also work great. I haven't tested MS Emulation a lot, but all the Sonic games for the Master System do run. Sega CD also runs perfect. There is basic support for 32x and the Pico, but haven't had too much success with either. There currently is no Game Gear support (Games will sometimes load as MS games, but colors will be screwed.) and understandably no Saturn or Dreamcast emulation (Oh, and almost forgot SG-1000!).
Hope that answered your questions thoroughly enough.