I just finished my playthrough. It's an improvement over past Cage games due to better writing, technology and characters, but it's still more or less the same.
Despite doing everything right IMO, not losing any QTEs, etc, I lost a major character and got a really terrible ending. After beating the game I found such a bad ending was unavoidable in my route, and the only way to get a better ending was doing some completely out of character bullshit some time before the ending. That kind of tragedy would have worked fine in a movie, but not here, since the game pretends what you see is the consequence of your choices, good endings exist, and for the most part being a good person and choosing 'the right thing' while not failing any QTE leads to good results.
I'm not a fan this narrative mechanic. My problem is that the bad endings are just bad stories which are not only unfulfilling, they also make little sense ('the hero found a terrible injustice, so he decided to do something about it; after triumphing over a number of obstacles, he slipped on a wet floor, broke his neck, and the villain went out laughing to the sunset; the end'). You'd think replaying the game without the mistakes to 'fix' the story would work, but at least in my case, it doesn't. I already invested in the story the first time, and watching the same thing with some bits changed feels weird, like some kind of fan fiction version of the thing. I'd say the version of the story staying with you is the first one you experience.
I don't know. If those kind of endings were reserved to failing QTEs and such I'd find them fine. Or perhaps the game could throw at your some horrible consequences for being a good person as part of some kind of 'reality is cruel' message, but I don't think that is what the author intended. I remember Until Dawn would also unavoidably kill characters depending on some random and inconsequential choices, but it worked better there. That game is based on teenage terror movies, so you'd naturally expect people to die left and right, even main characters, and even if it is just for shock value. In Detroit, the same thing just left me wondering what the hell I just watched.