Fantasy RPGs tend to do a pretty good job of this. The macro path your character follows is consistent, but there are choices and class-specific stories that create a sense of character.
I think the question comes down to the ‘role playing’ portion. I have no problem with single character games, and am not a 2077 hater, but would love to see more ambition around narrative.
No game _ever_ has been like this. You just can't get three completely different fully immersive all-spoken-dialog games for the price of one - unless the main plot is like 10 hours max.
Even the Fallout games have a few bigger decisions (FO3 had the choice of nuking either town), but the rest of the stat-based chat options are mostly for flavour. Maybe a few side quests have different endings or dead ends because of your stats, but the main plot is still essentially the same.