Couldn't care less what peoples say about games that i like. That said - id put "Grim Fandango" atop the "Worshiping Altar" and sprinkle it with "Monkey Island", "Dungeon Keeper 2", "Populous (the last one), "Morrowind", "Baldurs Gate 2 (and/or first NWN)", "Black&White", "Tiberian Sun" and "Beyond Good and Evil". Simply classics. Games of the second (or third, or first, or w/e) Golden Age of Gaming. Everybody who played those games loved them (pretty sure?).
All those "shooty shooty kill kill" games feel the same to me, smudged into one huge blob with arms, tentacles and guns sticking out of it...
Don't know anything about consoles and i regret never seeing Castlevania - sounds and looks as if it could've been in my "to worship" pile.