Well, let's talk about a better (IMO) game than Cyberpunk from the same company: The Witcher III. Geralt of Rivia is a nobody doo, but can take initiatives and at the end, people lives or dies because of him (even if he doesn't kill them) and even the future of a kingdom depends of his acts.Well, he says yes to what the women propose at his whim. I didn't take Naomi to her ship for a couple of months, for example. It just didn't interest me.
There is a limit to player agency in interactive games. Players can only be proactive within the confines of the universe the devs can create. In Cybrpunk 2077, what proactive actions can the MC take other than buying stuff and attacking people on the street, for example? Everything else is "saying yes" to someone. A few of the areas where the MC is proactive is dealing with the group dynamic in general. Now those are forced to a specific outcome so the choices feel less valuable to the player. Personally, I would have preferred my MC to discover what happens to people who leave the house when I toss her out the front door after she locked Cait out without her clothes, but I have very little tolerance for Tsundere characters. Thankfully, the dev very quickly toned her behaviour down after that incident or I'd have been done with the game.
The MC is in effect on a journey from zero to hero. He's the "Chosen One" -- the one with a singular ability that forces him into a protagonist role because that ability is necessary for the task at hand. He starts as an "Everyman" and grows into the "Hero" role as he gains experience and training.
To compare to a modern work, Luke Skywalker was a zero and Obi Wan Kenobi could be viewed and a the primary character in Star Wars. After all, what did Luke manage to do, really? The MC is the Luke equivalent.
Rae fills the archetype of "Sage" or "Mentor". She the font of wisdom and knowledge the others can use. She can guide others but not complete the task at hand.
I don't want the next part to sound harsh. The MC's failure to explore the ramifications of his world and his place in it is a failure of the writing. Either the dev has a blind spot and literally hasn't considered how his choice to allow the MC to have a non-estranged family and normal life prior to the incident should lead to him attempting to discover what has happened over the last few months OR the dev is attempting to keep the events in the world unknown from the player to maintain suspense in a way that forces the MC to carry the idiot ball and simply never ask basic questions. Either way, I think it fails a basic sniff test.
Luke Skywalker is a nobody at first when Obi Wan Kenobi finds him because he's a just a teenager and he spends a lot of time training with him and Yoda before doing something. But then he becomes in someone and does things. Saving Leia at the beginning of the third movie, for example, fighting Darth Vader, gaining the friendship and respect of Han Solo and other characters... And even when he's just a trainee, he has a background. He's a good pilot. He knows about robots and how to repair them. He has hopes and dreams... What do we know about MC hopes and dreams, abilities, past...? Nothing. How MC changes during his journey so far? Well, he learns some magic abilities for the benefit of the plot, but he doesn't seem to be wiser, kinder or more charming than at the beginning of the game, or change his personality. He's doesn't evolve, is the same blank canvas. For example, he can be a nice guy or an asshole that gives rude answers and pervs the girls the day 1 and the day 365. How could someone empathize as a player with a character like this one?
I suspect that most of the people just forget about MC when playing, and look at the girls.