Well, it's not action or adventure, but it is horror, a bit.
My absolute favorite has always been Shin Megami Tensei: Nocturne. It's a turn based JRPG, but it's pretty far from the standard fare in that regard. It's kinda like pokemon on a combination of steroids and acid.
It manages to avoid a lot of RPG tropes, as well. the combat system, while turn based, is a little more in depth than "i take my turn, then you take your turn" Each side has a number of "Press icons" determined by the number of characters on their side. Each press icon give you the ability to do one action, but critical hits, exploited weaknesses, and waiting only take up half of one icon. two icons are taken when you miss or hit an enemy with something they are resistant to. Your whole turn disappears if you hit them with something they reflect. Remaining half-icons can be used if they are full icons, except that they can't be split.
That means that if you plan properly, you can take 8 actions in one turn. And if you don't plan properly, you run the risk of giving away your entire turn.
EDIT: Oh, also, the game begins with the end of the universe, so there's that.