Sleeping Dogs didn't make you feel uncomfortable? The whole game had me questioning choices and morals, which to me was the sign of a brilliant narrative. Sure the individual fights and sequences rewarded violence, but you take a step back and look again, and it's monstrous. It's a perfect moral dilemma - was it worth all that just to (almost) take down the Sun On Yee? The losses along the way seemed to mean something, and it was almost always a direct response to your actions. That didn't make you feel uncomfortable?

To answer your original question, it's a great argument against the 'games desensitize' school of thought. It causes you to think, question, and weaves a narrative similar to 'deep' books and media. It's a sign of maturity in a relatively new narrative form, and I think experiencing mature narratives is important. (And by mature, I mean ones that lead you to question and ponder, rather than thrusting interpretations in your face).

tl;dr I think it's valuable.

-- written by @dawmail333 in response to http://blog.greenmangaming.com/2012/08/from-gratification-to-horror/