I humbly disagree.Generally you can’t make a arch enemy something esoteric.
So you can’t make a death, City or a biochip since they don’t have the personality that could shape the relationship with the protagonists.
And this relationship is what is producing the tension in the story.
They can’t because they have no agenda.
Not at least in the mainstream release.
You can make a character story where it’s about the character and how he or she reacts to some unchangeable events. Like for ex death.
this was the premise of Nier Automata that was executed into the true masterpiece
but here it’s not the case and never will be.
tho with the rest I admit that removing plot cancer would fix most of them.
This is also why the plot cancer is so bad.
The sword hanging over V shaped the character in an interesting way. Suddenly, big money and fame were secondary and V started to concentrate on what is important.
Characters facing certain death are able to do astonishing things. Elysium come to my mind.
Another example of the protagonist dying, while achieving something greater.
Certain death could have strengthened V in the long term.
It's off course up to how you play the character within the limitations of the game.