I don't believe that's the main thing here, I think there's a subtler but more serious conflict. Sure, the cinematic presentation of third-person can help in some respects, and you've got Deus Ex as a good example of striking a balance, but then you've also got titles like Thief, exclusively first-person with no plot agency, and yet Garret's still a more engaging protagonist. The rub, I think, is in the writing...
Consider this - what do Geralt of Rivia, JC Denton, Adam Jensen and even Garret all have in common? No, really, take a moment to think about it before you read on. Okay? Right, well if you answered "they're all stoic types", you're right on the money. The way these characters speak, what they say and how they say it, presents them as reserved, calculated, even-tempered individuals, which creates a fictional space between what they're saying and why they're saying it, a space for the player to insert themselves into. So even as Geralt has far more backstory and established relationships, his measured, often laconic mannerisms allow the player to put their own spin on interpreting the character's inner processes, on "what he's actually thinking."
This is not the case with Cyberpunk's protagonist, who is consistently impulsive and extroverted. While lacking much of a personal history, V's character is right there on the page - Stupid Asshole™. And if you can't relate to that, well, tough luck, there's no room for you to read things differently. And while I can understand that this sort of scumbag archetype goes well with a cyberpunk story in general, it can be a really bad fit for a videogame promising character agency. So even though V's role is well performed, plenty of players will have trouble investing themselves into that role.
To sum up, if you're gonna have a fully-acted protagonist in the context of an RPG, you're best off making them the strong, silent type, because with a stoic PC, less is literally more. Have I already made this argument? I forget. It's a big thread. I'll probably make it again at some point.