I'll always defend Heavy Rain. While the writing is terrible, the story is full of holes and it actually
cheats with its murder mystery, it's one of the most genuinely impressive choose-your-own-adventure games there is. The story will branch in meaningful ways from very early on; the map of every possible route would be quite staggering if you plotted it all out. It's in a whole different league from Until Dawn in terms of complexity, quite an amazing feat.
It also has some pretty challenging moments of 'gameplay'. It's obviously all QTEs, but some of those QTEs take some serious finger gymnastics to pull off, and there are genuine stakes to those scenes. If you don't find the right evidence, you won't solve the mystery; if you don't escape from bad guys your characters can end up in jail for the rest of the game, or just dead, and the story will change to account for it. I think it's such a cool game, even if there's so much dumb stuff in it
Beyond Two Souls is just trash. It's almost entirely linear, with only a handful of choices the player can make that have zero lasting effect. You can choose to terrorise a group of rowdy teens and
burn down their motherfucking house, and all it gets you is a scolding from Willem Dafoe that never comes up again. You can reject the prettyboy love interest all you like, but Ellen Page still ends up with him. The gameplay is utterly braindead, to the point where your presence as a player is treated more as a nuisance than as a necessary part of the bargain. "Ugh, I guess we should make the player do something in this scene." It goes without saying that the story is stupid, but with nothing else impressive about the game there's nothing to distract you from it.