One of the best sound archives I ever came across was the one from Ragnarok Online. All you need to do is download and install it, and quite possibly you can grab the wavs straight from one of the folders in its installation directory. There is a slight chance that you need a simple ripping program to extract them from a different type of file. I am not exactly sure though, as it has been such a long time since I did it myself.

Anyone looking for a collection of generic sound effects and especially game specific should check it out.

Yeah, I can see that. The majority of the sounds are of pretty high quality, though. With a fair amount of them probably being created from real word sounds. I don't think that exactly addresses your concerns, but if it is a grating and overly generic quality of sounds that you are trying to avoid, it may.