I like gore, it rienforces the visceral horror of an event- splatter, pools of blood, eviscerations, all bring home the inherent danger, the fear, that this could happen to you.
Like memento mori, only more immediate- not "as I am, so shall you become", so much as "you gonna get murdered!"
Having said that, God of War III is too much for me. A fictitious modern- badass- style demigod grinding up my favourite mythological monsters in a brutal and abhorrent, and utterly evil, fashion attempts to demean the iconic and emphasize the 'coolness' or toughness of the 'protagonist'(What I mean to say is, is that I'd rather watch monsters slaughter people horrificly, and not the other way round. I KNOW how horrible people can be- that's called real life.).