I'm playing it right now actually. I've got it off Steam; I had never played the non-enhanced version before. And I'm having a good time so far, two chapters in. The story is decent, with choices that seem to actually matter and go beyond the "be a saint/be a dick" dichotomy you'd find in, say, a Bioware game. There are plenty of moral gray areas, in a way that I find refreshing, and that makes the more benign characters more effective.
I met this knight of a religious order in some sewers. We were hunting the same beast; he volunteered the kind of information you usually have to pay for, and then we joined forces. And all this time I'm thinking "wow, what a decent chap". We parted ways, and every time I run into him I'm actually glad to see him even if we don't interact much. He's not a shiny, formidable badass, or some sort of comic relief. He's just an honorable guy who killed a cockatrice with me and offered to help me out in the future if he could. And I give a crap about him! I'm not sure why, but it works. I guess there's a particular humanity to this setting.
As for the actual game,
Yahtzee describes it as a single player MMORPG, a summary I find almost entirely without merit. There are a bunch of "bring me x ghoul testicles" quests, but they're painless in all regards. They fit the world and your character's job (professional monster hunter), and you're likely to accomplish them by accident while you're going about the main quest. Plus they're mostly optional, and the rewards are fair.
And the combat is fun anyway, so I like an excuse to kill stuff. It's a pleasant affair of preparation, position and timing.
I don't care much for the sex stuff, though it must be said it's not a detriment to the game unless you're opposed to the idea on principle. It's simply
there, and comes down to an occasional "Bone her? y/n". It is kind of immature in some aspects (like the cards), but overall it's not like it's porn. It's almost a James Bond thing. You just happen to come across spectacularly easy women every once in a while, and doing the deed doesn't actually feel too out of place.