I just noticed this, had to reread it; In Fallout 4 you are Nora/Nate, parent of a kidnapped child. The character is not you, You can customize that character but its still the same parent who is looking for a stolen child. The only difference is that you can change the name aswell.You should try out Fallout or Skyrim. Those are sandbox RPGs where you have complete control of the story. Cyberpunk is a narrative experience.
In Fallout you side with a faction and that faction rules the commonwealth(though minutemen will probably be canon if ever mentioned). In CP2077 you can attack Arasaka or go with their plan, the outcome of both differ for you and for Night City.
Even in Skyrim you get more options to decide who your character is, but you will always be the dragonborn who was destined to fight Alduin and Miraak. The story doesnt allow you to side with them. You can decide to destroy the brotherhood instead of joining them, just the same way you can decide to ignore Panam after the first mission with her, which will lead to her family being wiped out eventually(dont want to go into spoiler territory, if you played you know).
The similarities between the games are not a big as you think they are. It basicly means Cyberpunk 2077 is a 'sandbox rpg', like Skyrim and Fallout.
And I explained why it isnt the case for you.And I explained why that isn't the case.