I've already posted in another thread, directly in response to the OP's apparent vendetta against David Cage, who I suspect stole his high school girlfriend or something. There's really nothing I can say to change his mind, as he's pretty clearly completely absorbed in his own opinion and unwilling to accept that other people have different opinions from him.
So I'm going to say this: pointing out plotholes in movies, games, books or really any medium does not make you inherently better than it. Plotholes are things that inevitably happen if you scrutinize a work of fiction closely enough. They can be found just about anywhere, from The Lord of the Rings to Inception. In the same vein, the existence of plot holes do not immediately devalue a work of fiction. For example, the classic LotR plothole is the "Why didn't the Fellowship just ride the Eagles to Mordor?" argument. Regardless of what the answer is, (and the fact remains that the answer is a pretty shitty cop-out) does the fact that this was an unconsidered option devalue the entire series?
Movies and games especially are intended to be experienced moment-to-moment, and so it's difficult to notice plotholes until after you have finished experiencing them. If you notice the plotholes as they happen, then either they are particularly egregious or you weren't really immersed in the experience at all. If the latter, whatever, that's fine, play games how you want.
The "plotholes" you suggest (at least for Heavy Rain, as I can't testify for or against Indigo Prophecy's writing) are trivial matters. You question character motivations that may seem irrational from the standpoint of an observer, but are really incredibly common behaviors in similar stories. The double-bluffs, the love interest, the rogue cop who believes in you--come now. Do not stand there, throwing these tropes at us and demand that we accept them as proof of David Cage's failure as a human being. You are being petty.
The more I look at the original post, the more I cannot imagine that it was written with any seriousness. It stinks of narrow-mindedness, of a dogged need to convince yourself and everyone else that your opinion is correct, despite the absolute minimum effort you put forth into formulating it. And then you have the gall to dismiss everyone else's opinion as "WRONG" and even have some half-assed conclusion that contradicts your entire point and shatters your credibility ("sure there are much worse stories, but those are in games in which story is an afterthought, and I like those games, and don't like Cage's and that's why they suck").
So here is my suggestion. Go outside, take a look at something that isn't the Internet or a video game, or anything on a screen really. Take a moment to appreciate the fact that you are, in fact, alive. When you've calmed down, maybe you'll remember that David Cage didn't actually kill your family, no matter how hard you try to convince yourself he did.