azraelck
Angel of Cookies!
Eternal Darkness: Sanity's Requiem for the Gamecube. It's old now, obviously, but still a solid enough title if you can find it. Third person perspective.
No, maybe you missed the part where I said "imo".
It would be hard to argue against it being the best to take place in a sci-fi setting though.
There are very few survival horror games that takes place in a sci-fi setting.
The AvP games had some scary moments, but I only found the Marine campaigns to have any real creepiness. The Predator and Alien campaigns were more pure action.
Never mentioned Waxworks and Elvira either. They are a bit old now I guess.
Realms of the Haunting is also very good, but it will need Dosbox and the graphics are very dated, but still an excellent game.
Sanitarium
A very good psychological horror point´n´click adventure game.
Original plot (basically a journey into main character´s deranged mind), a lot of logical puzzles thematically well integrated into the story, eerie atmosphere, great art design. Highly recommended!