If you have a decent computer, you can eliminate most, if not all graphical glitches and sound problems with most of the games listed above.
The best graphical plugin is Glide64 "Napalm WX". It's in constant development and has gotten extremely accurate, eliminating almost all graphical glitches in games (that don't have to do with the emulator core). Even problematic games like DK64, which can never render framebuffer effects perfectly in Jabo's plugin, can be made to be 95% perfect. The only issue is polygons sticking out of the characters at times, but that is the fault of Project64 itself and the emulator's core having timing issues. Before PJ64 1.6, that game was almost unplayable (in certain spots, you could have issues) thanks to fucked up timing.
I've even found a fix for Resident Evil 2's voice acting. The priorities for the graphics still aren't perfect, but you can get the voice acting to work properly with the right counter factor (2 is best for this game's timing) and the right sound plugin (I use Azimer's HLE audio v0.56 WIP2). Make sure all game specific options in the emulator are disabled except "RSP Audio Signal" and "fixed audio timing". As i said, priorities still messed up in the level backgrounds and character models, but i imagine it will be fixed soon as Glide64 is always being updated every few days (via public compiled repositories).
There are a few games that won't boot at all, such as Indiana Jones and the Infernal Machine. The core can't handle that game at all yet, but at least there's a PC port of that if you want it. I think the unworking games are listed in the GameFAQ. Most all problematic games can be fixed with Glide64 though if your PC is decent enough. I'm sure a lot of us now have around 2.5-3ghz PC's by now, with at least some decent GPU's. Should work fine if you can configure it correctly.