One of the only video games I have truly been transfixed by, not involving a skateboard, is Eternal Darkness.
I owned it a few years ago, but had since sold it along with all my other GameCube games.

The game's setting is centered around a mansion in Rhode Island, the home of the protagonist Alexandra Roivas' grandfather and the mysterious book known as the "Tome of Eternal Darkness" that Alexandra finds there. The game is presented in a third-person action-adventure perspective in which the player must navigate a number of locations as twelve characters spanning different time periods. The game utilizes unique "sanity effects" to enhance the gameplay.
I can't wait!