Strangely enough, playing through it right now.
Dark Messiah: Might and Magic (PC. 360 port was horrible).
Has a moderately interesting story, a nice twist mid way through (that would have been harder to see coming with better voice work). Lame ending though, and the voice acting is some of the worst I've seen.
What really makes it stand out is the combat. If you want to be flying through waves of enemies, without breaking a sweat, this game is not for you. Combat is visceral and unforgiving. Any more than 2 or 3 at a time and you've no hope of a stand up fight.
You need to learn to use the environment and be clever. The game uses Valve source engine for physics so there is a lot to do.
Good example from earlier today. I entered a room with 3 orcs (playing as a stealth/mage character). Backstabbed one without getting spotted, but he fell when he died and the others saw the body which put them on alert. I moved to better concealment, cast Charm (turns them to your side for a time) on one of them. Once one of them was dead I used Telekinesis to throw a large rock at the last one, finishing him off.
There are some issues though. The controls are a headache sometimes. It's very easy to get caught on the environment, which is especially frustrating when the game throws in some mild platforming. There is also some hit detection problems, where weapons (especially enemy ones) seem to have a farther reach than they should.
Overall, the game is definitely worth your time if you have a modest PC. More than anything else, I love it because it is different. Imagine Half-Life 2 with swords and sorcery and you'll have a general Idea.