For me, the best video game has to be Eternal Darkness for the Gamecube. It has an actual sanity system and, without spoiling anything: there are amazing side effects to having reduced sanity.
The best game in general is undoubtedly Call of Cthulhu by Chaosium. The seventh edition of the game is completely backwards compatible and so there exists 40 years of amazing horror scenarios.