There are probably a lot of games like you say. I know. Deus Ex, Fallout 2, Vampire The Masquerade.
I never said Cyberpunk 2077 would be necessarily bad just for the FPP. I only said that there's a certain pattern for the past decade or so where TPP games excel over FPP games, reflected in GOTY...