You want a good review? Here:
Notice that this guy basically lists nothing but FACTS about the game. No opinions here, minus the occasional comment, such as his views on the music.
Others have pointed this out already, but it bears repeating: this guy lists some facts about the game in the midst of a lot of his opinions on how fun they make the result.
I'm going to assume the points he brings up about promised features that aren't in the game are true; that sounds like Mojang's performance trend to me. Village NPCs are completely useless from a gameplay perspective, yes, that's not really debatable: they do absolutely nothing aside from 1) exist and 2) wander aimlessly (often ruining their own crops). They're no different from the various animals that have existed in the game for quite some time from a behavioral perspective without offering any of the animals' various useful products when killed.
He's also right about the monsters' AI being practically nonexistent and combat itself being very simple and easy. Unless I'm completely swarmed by enemies in an area that's difficult to move around or escape, or I run into a baddie early on before I have any armor or weapons, I'm pretty much not going to die in combat, end of story; once I've got a full set of iron armor and food, I pretty much only die from lava mishaps or unexpected falls. I would imagine this is true for most players who are at least passably combat-savvy.
However, when he says that because of these flaws the game can't be good and only "autistic" people will enjoy the construction for any prolonged period of time, that's an expression of how little he enjoys playing the game, not a factual description of how much everyone, or even a majority of players, will enjoy playing the game. I posit that the very existence of all the rabid Notch fans mentioned earlier in this thread suggests a good number of people do very much enjoy Minecraft's construction capacity (though I sincerely doubt many enjoy it for its combat or NPC interaction potential), which calls his judgement into question. Unless, of course, it was a joke...in which case it just wasn't funny. But that's okay - plenty of people who try to be funny fail at it. It happens.
I'd say trying to review Minecraft demonstrates the inherent problems of reviewing video games on the whole: it's a highly subjective thing to do, even more so than movie, music or book reviews. For the most part, you can anticipate a box office bomb by judging a movie's technical and genre content. You might come across an unexpected hit out of nowhere, but by and large you'll find some point of widespread agreement as to whether a movie's cinematography is excellent or sub-par, whether a given actor's performance makes a character come to life or comes across as flat and uninteresting, whether a writer's prose is gripping or overwrought, and so on.
But with games? There are folks who'll rate a game down hugely for crap graphics despite good gameplay and others who will ignore those graphics because they value the gameplay. There are folks who demand compelling story and others who are happy with "run to the right and shoot" as the extent of a character's motivation. There are players who will take nearly nonexistent objectives as an invitation to create their own with the tools available and players who think those tools are wasted without proper objectives to achieve with them. It's impossible to "accurately" review games for the majority because, well, there isn't a majority in gaming. There are too many different kinds of players who enjoy different kinds of games and qualities within games, overlapping and splitting apart over seemingly minor features or something as simple as differences in aesthetic preference.
Point being, given the popularity and community support surrounding Minecraft, it would be foolish to judge it a failure as a game simply because someone didn't like it, or even because it's incomplete. Do I find the game's obviously unfinished design disappointing? Yes, extremely. Do I find its graphical limitations unappealing? Yes, especially with regard to the living inhabitants (the block world, not so much). Would I call it a bad game because of those things? Considering I've put at least a hundred hours into it all told, no, I wouldn't. I wouldn't have kept playing if I wasn't enjoying the experience, however half-baked it may be.
To put it another way, the fact that it could be better than it is doesn't make its current incarnation bad.
On separate note, regarding its comparison to Terraria: combat in Terraria, though at times frustrating early on and entirely boring once you've hit the cap, particularly if you use intelligent strategy in addition to powerful equipment (seriously, you can solo the hardmode bosses without much trouble if you have at least an Adamantite repeater, a healthy supply of unholy arrows (vendor-sold) for it, Mythril or Adamantite armor, and a platform of hellstone to stand on; a cross necklace and starry cape make this method even easier), is far better than Minecraft's poor showing in that category. It's also more visually satisfying, though I think I'd give the nod to Minecraft on music; Terraria's tunes get on my nerves after a while (totally subjective quality there, of course).
However, in terms of world generation and construction, Terraria pales in comparison. Not only is construction more varied in its possibilities in Minecraft, it is also - and this is important - simpler and smoother. Big ugly blocks make for easy construction compared with Terraria's many tiny blocks you have to place just right with your cursor, then add background walls that can very easily end up looking silly if you stick them out a square too far so that they poke outside the blocks, teleporting and flying enemies can disrupt your construction projects in far more obnoxious fashion than creepers do, and so on. You can still be creative in Terraria, sure, no question, but it's a far more tedious method to do so with less reward in your end product. As for world generation, while both are fairly repetitive, Terraria is the more so, given any world will always have X flying islands, X corruption chasms, a dungeon and a jungle at opposite sides of the central spawn point, oceans at the extreme edges of the world, etc. Terraria's worlds lack much in the way of variety. Exploring the underground caves feels like a chore to get to the next goal: reaching the underworld, finding the last 20 adamantite I need, farming souls of night, etc. By contrast, Minecraft's worlds, though repetitious as well in terms of textures and the total range of possible finds, feel much less predictable. I've spent entire days exploring my way through a single lengthy interconnected series of caves-into-mineshafts-into-crevasses-into-more-caves, and the structures and spaces I came across always seemed at least somewhat unique (With the exception of crevasses which, I have to say, I think were the worst part of the "adventure" patch; they're just so...bland, these wide-open scars in the ground with nothing in them. I prefer the honeycombing caves and abandoned mineshafts with their more mysterious pathing and interweaving patterns. Crevasses are too static in their appearance. But I digress.). It may sound strange, but I have more fun exploring in Minecraft than I do in Terraria, despite the lack of a Dual Hook, Glowsticks or properly threatening enemies to spice up the experience.
They're two games that offer very different gameplay experiences. I've "finished" both - full Hallowed set with a Godly Excalibur, Megashark and more accessories than I have room to carry in Terraria; brick house on a high plateau overseeing an NPC village I guard from monster invasions, with a fully-shelf-stacked enchanting and alchemy alcove in my basement and, below that, an obsidian vault in which I've locked up the Ender Dragon's egg in an iron bar cage in Minecraft - and they were both satisfying and annoying in different ways. In the end, though, I think Minecraft is the one I'll be revisiting more often; there's just nothing to do
in Terraria once you have all the gear and have conquered everything, at least nothing that I couldn't do better, easier, and with greater enjoyment in Minecraft.
This ends the wall of text for the evening.