Yeah, great, sure.
That may be very useful when you want to write a novel.
That's plain bullshit when you want to write a RPG scenario.
Someone mentioned the Call of Chtulluh somewhere, in which the investigators either die or are turned insane by the madness they uncover. Well, that's the point in that gothic horror game : coping with Lovecraft's creation.
In Cyberpunk 2077, the writing is just lame.
You're given a goal. The Act 1 is useless (or badly set). You're supposed to get a best pal ever (and I was sure he was to die or somewhat disappear after 5 minutes of gameplay), your lifepath serves nothing but to introduce the world. It has no influence on the remainder of the game. The real thing starts in act 2.
Some mention a feeling of emergency. I did not feel that emergency (despite the narration heavy insistence). There is no countdown, so, why hurry ?
Then there is all the story we know up to its endings.
In a novel, as a writer, you're god almighty and do what you want with your characters.
As a game master of a RPG, your scope is not to follow some template to build your story but to entertain your players and have some good time with them. And CDPR fails miserably at that in their endings which does not reward the player / character and which are simply hammered on the player / character because "fuck you, that's my story, so behave".
CP 2077 may be some nice novel, but it is a very bad RPG (or game) scenario.
Freytag's Pyramid is great for heroic tales like Beowulf, or if you want to set up the rise and fall of a character like Lord of War (movie with Nicolas Cage). CP 2077 does not that. You don't rise, and you crash pretty fast.