The lights are on
As someone said, sometimes you need to look past the bad to see the good.
The way in which the narrative is told is fantastic (Some people think quick time events are a pain, but this game makes fantastic use of them). Some of the holes can probably be debunked. And it's especially emotionally resonant, something you'd expect from the highest works of art. I'm not dismissing some of the things you said, and you wouldn't think the game is art because of what you said, but you shouldn't let these things stop you. At least you can feel the characters' pain. And at least David Cage is trying to do something different.
I hear Beyond: Two Souls will be an improvement in terms of performances, and probably characterization. Hopefully it will be in the writing and narrative department as well.