I agree with Niara.
Nobody ever said that adventuring should not be dangerous or deadly. It should be.
All we say is that it is bad design if the GM or dev thinks that throwing SoD or OHK at the player is the best way to keep the player engaged and to give you the feeling that your adventure is sangerous.
Since SorcererVictor mentioned Kingmaker.
I finished the game recently and I remember 3 enemies that used such attacks.
- Vordakai: You are in a dungeon full of undead and you know you have to fight against a lich, so you are prepared.
- Medusas use true strike + finger of death delivered with an arrow. The first time I was surprized and some chars died. ( I expected petrify but not FoD from a medusa)
Once I knew I could handle them
- The wizard who comes together with the fiend at the lowest levels of the depths cast mass ice prison. Even if you prevent paralysis, the spell does damage every round for over 20 minutes which is a death sentence and he always casts this first against the party. Took countless tries until I could kill him before he could cast a single spell. His fiend buddy was a cakewalk.
Even with only a few enemies that use such spells, I would say that Kingmaker is a great game and it is often very deadly if you are not prepared.

Prof. Dr. Dr. Mad S. Tist

World leading expert of artificial stupidity.
Because there are too many people who work on artificial intelligence already