So, well, might as well read all there is in wiki, purchase tabletop guide lines. Check all what Pondsmith has to say.
Wont change the fact, that Cyberpunk world is ruled by CORPOs. Standing up to CORPOs never ends good to anyone. Well, even ones that have nothing to do with CORPOs, like Takemura or any other people that live in slums of any city, will get rekt by CORPOs if so they wish. People with doll chips - are run over by pawns of CORPOs. Very minor set of people have even a chance at better life. Like sister of a food vendor - and they get a "warm" treatment from neighbours. CORPOs can kill people without any CORPO protection without any repercussions. And nothing there to be done. While CORPOs themselves are working to death to stay in position they already have and go over the top to get better.
V - tried to go on toes with Arasaka - and here we are, claiming that V, and we, as players, are heroes because Pondsmith said so.
What V does - fights for survival and revenge(if it can even be considered revenge since that is unattainable for V in any fully meaningful way that will impact Night City by players actions) by going on spree of disabling or killing other people. Doing things necessary to get power and money while finding a way to survive. So for whom is he exactly fighting? He has no family, not even a mention of them. His friends are Vik, Misty, possibly Padre(more of a guy to do biz with) and Jackie(can consider his mom as well). No one of them, outside of Jackie have anything they need V to fight for them. They are pretty much set, doing what they want to and doing fine, V or without V. Only new friends or love interests can be considered a new family that will actually fight for V and not the other way around. And die as well if player takes them on a last mission. While player can just skip all love interests/friendly interactions or even go full solo.
So here we go again. Cyberpunk world is a place run by CORPOs, they win - you lose. Always. You can be considered a hero for trying to stand up. But like any other revolution, one person is not enough. Even group of people wont be enough. You can even think of Johnny as a wicked version of
William Wallace from Brave Heart. Failed one as well. So try again telling that Cyberpunk is just about characters as heroes because that is only part of is going on