Thief series. The main character is weak and powerless and in any confrontation with the monsters she is at best going to come out beaten and bloody; far more likely she will end up dead, and quite suddenly too. Even late in the game, when she is armed with flamethrowers, shotguns, and grenades, battle is better avoided even against the weakest of enemies (and against the eponymous alien, there is no question: if it catches you, you are dead).
Castlevania; myself, I just saw it as an excuse to make me retread territory I had already explored.
Let's Play of the game on YouTube and maybe just rent the damn thing for a weekend if you are a graphics-whore (like myself) and need to see the textures close up for a bit. If you like what you see, then wait for the game to inevitably hit the bargain bin. I think it's a game worth checking out - at least for a while - but not worth the investment of full-price or a thorough play-through.
Completely Arbitrary Numerical Score (CANS): 2.2178655523678211956757239 (out of something)
Sure, it's better than most games but wait until its on sale.