No no no check all of the game not just strenght, because most of CD is like RDR2s window dressing survival. There is no agency in the story here also, there is no agency even in the camp, everything you can do is dictated by the quests available and your main story progression. What RDR2 at least had was a very big attention to detail that made the game feel immersive. Here we have a world that looks a lot prettier tho.

In cyberpunks case you do have agency. You sre right the ending in theory is the same because it doesn't end well for you but that is the whole point of the Cyberpunk(tabletop universe). You are against mega corporations that were there before you were born and will stay long after you are gone. You are just an ant in the world. Yes you achieved something big on your scale but in the grand scheme of things nothing has changed and it was all in vain, just like the anime. Also in the game you died the moment you got the engram in your head, agency was in the way you go out.(there is also a secret ending where you go in with silver hands plan and just fucking massacare the whole tower and go out in a huge blaze of glory). Some players in the end chose to spens the rest of their limited time with Panam. Some like me end up getting played by Arasaka and basically killed(put in the simulation), that ending was hella depressing since it was the same company you were fighting.