
As for a Resident Evil 1-like, you should check out "White Night" on Steam. It is a monochrome, black/white 3D exploration game that looks like Sin City and you investigate a mansion similar to the spencer mansion in RE. I'd wait for a Steam Sale for a price drop, but it is worth checking out.
As for Metroid Prime, I think that at the time it released it was compared to Halo and because it wasn't online/multiplayer/action heavy, it was basically trashed, thus there only seem to be Nintendo fanboys who really appreciated the game and preferred the slower exploration and atmospheric emphasis.
Shadow of Colossus really needs a sequel dammit! OMG imagine next gen visuals, or at least a remake. I think God of War has some awesome giant ass monster battles, but yeah, need a Shadow of Colossus sequel.