I think something like what modern Deus Ex games had is a perfect balance of 1st and 3rd person camera. Most of the exploration, sneaking and shooting is first person but whenever you enter cover or shimmy along the walls, you get a 3rd person camera so you can see and aim better. It's both practical and immersive IMHO. Takedowns were kinda bad since it took you into a basically cutscene every time but if done differently, more seamlessly, i'd be a good fit for cp2077.
Also I wouldn't mind 1st person camera in vehicles at all if it was actually good, but it feels like I'm driving from the back seat, FOV was just terrible. And that's coming from someone who enjoyed doing GTAV heists in first person mode...