Ignore the plot holes, they're easy enough to get over. There is emotion in this game unmatched by an other.
The gameplay is satisfying in the way Fallout 3's VATS system was, even though you are only responding to prompts and not necessarily controlling, per se, it is still incredibly fun. The chase scenes, fight scenes, and other gun related action sequences are executed in a believable enough fashion that it leads to what can only be described as amazing.
The cinematics make it look like the game is actually responding to your clicks and not just going along a certain pace. Everything is fluid, which is the most surprising part of the whole thing. The game is also one of the most addicting.
Unfortunately, it is done far too quickly. The plot twist is something that we all probably should have foreseen, but it is one of the most surprising twists in any form of media I have seen in recent years.
I would personally recommend renting this game and doing two or three playthroughs, seeing each of the possible changes and "what if" scenarios if you play things differently.