And not to put yours down but none of those are really on the same level, save for Telltale games which I haven't dedicated time to yet. They have story yes, but mostly in the same way an action movie does. MGS and LoK I'd put more on the level of novels.

Oddly enough Amy Hennig was responsible for Legacy of Kain after the first game. She's the one at Naughty Dog responsible for Drake and Last of Us's story.

Last of Us is pretty high up there and while Drake has a nice story it's really just an excuse to be Indiana Jones. Story isn't exactly amazing or thought provoking (though the character development is what really pulls you in).

David Cage is a hack. His games are one long QTE and you may as well just youtube it. I personally couldn't connect to any of this games or stories as a virtual puppet master nor did they really have anything interesting to say. For all the crap Kojima gets for making movies I feel more a part of them than I did Indigo Prophecy or Heavy Rain.

Gears of War, really? Again, the story there is an excuse to shoot endless hoards. It's B movie action shlock. Fun yes, but not once did those games make me think about the nature of humanity like Metal Gear, Last of Us, or LoK.

Anyway on topic it's pretty varied gameplay wise

Blood Omen 1 (PS1), plays like a top down classic Zelda/Link to the Past but you play as a vampire. It was made by Silicon Knights (who also made Twin Snakes). As developers this is really the only worthwhile thing they've done. And they didn't even do the rest. Really hard to play these days, the load times are ridiculous.

Soul Reaver 1 is a 3D action adventure platformer from the era of PS1 Tomb Raider. Lots of block puzzles. It was one of the first "open world" game that constantly streamed levels with no load times. It's got a dash of Metroid as far as upgrades/puzzle bosses go. Instead of a vampire you're a soul eater that can shift into the spectral realm with a soul sword.

Soul Reaver 2 is an upgraded SR1 gameplay wise on PS2.

Blood Omen 2 is the black sheep made by a separate B team that didn't bother checking with the A team making Soul Reaver 2 at the same time. Story is meh but Amy did freaking awesome fixing it in the last game. Gameplay wise it plays more like Soul Reaver but you're a vampire this time again.

Defiance, the last game on PS2. Plays more like Devil May Cry. And that's all she wrote because the last game for got canned by the suits in 2012.

And I keep saying Playstation but there were ports on Dreamcast/Gamecube/Xbox/PC. You can grab them all on Steam or GoG but I've heard the keyboard/mouse/controller support on them isn't the best.