I have to say Eternal Darkness's overall story didn't impress me. I felt disconnected from the characters, because I played them for such a short time and didn't care if they lived or died. Even the holy crap moment when I played a character that just walks around and is eventually killed with nothing you can do about it. Shocked me...but then did nothing for the story.
However, the atmosphere and sound design of that game was so great, I had to stop playing because I didn't feel right playing the game. In that sense, the game is an amazing and incredible success. The game just worked at making you feel some dread.
In the end, Eternal Darkness to me is a strange game...it is not as good as the hype and has several problems with the story and game design, but what it does right, is pretty dang great...if not bordering special.