I think its a fantastic game personally. Though, even before the game was released I predicted on this forum the game would get torn a new one by the interwebs. It's a horror game in the way it delivers tension rather than full-on scares like Alien Isolation or Outlast. You are constantly outnumbered and low on ammo so having an extra bullet can mean the difference between life or death. The game plays like a slower-paced Resident Evil 4 and goes through all of that game's motions: creepy village, haunted mansion, collapsed urban terrain, all the way dowh to..you guessed it. Even the enemies behave similarly as Ganados with the same types like the axe wielding one, the chainsaw wielding one, the armed one etc. And remember the ride in the pick-up truck in RE4? Well this game has you similarly covered.

There is even an Umbrella-like conspiracy.
To be honest this is the game I wanted RE5 to be, and I can't really think of a higher praise I can give Evil Within. I enjoyed this game way, way more than every other game released this year. It's atmospheric and tense yet it still has fun and satisfying gameplay(something nearly every horror game lacks). Those who say Mikami doesn't understand horror, I disagree. But his style of horror has always been about racketing up the tension, yet still having the means to fight back. This concept is what makes a fun
game and is something more 'pure' horror games like Alien and Outlast misses the mark on. Mikami has this technique down as I just find his (survival horror) games satisfying in ways other games don't. Throw in a few kick-ass classic horror movie references and you have vintage Mikami stuff.
I even liked the story and the protagonist, Sebastian. The story is like what you get if you mix The Cell with Inception. I agree with Yahtzee that the levels don't make sense, but that is the point as you're literally in the mind of a psychopath(that's also why Psychobreak is a more appropriate title for the game). Sebastian had to endure something similair as Ruvik's childhood trauma(which explains the village/mansion levels and enemy types) but he carries it with a typical stoic demeanor(though when you leave the controller idle you'll notice he's in a bad place mentally). Without venturing into spoiler territory when Sebastian's partner wants to attempt suicide more light is shed on the matter.
Horrible things happened to characters in this game but it's often told so matter-of-factly and without any 'woe is me' garbage that it lacks any emotional punch. Which is another thing I really like about the game. I always find overly emotional displays of sappy drama really irritating so there being a mere whisper of suffering(which is a distinctly Japanese thing I guess as I only know Japanese games that do this) much more interesting and intriguing.
So yeah, if you're only slightly interested in the game just check it out for yourself to see if you like it or not. Yahtzee's taste in games might not be your own.