Dino Crisis, Diablo, MGS2/MGS3 are the ones that first come to mind.
But I also recently played RE: Code Veronica and geez, that game has some very rough edges and could genuinely use a remake. Not only in the gameplay department but the story specially had some very interesting ideas but very lousy execution in the original game.