Rockstar games seem like they're built to lose focus on the main plot. I think that has a lot to do with the fact that R* appeals to both hardcore and casual gamers. People who play Nier: Automata or God of War played RDR2. People who only play Madden and Fortnite still played RDR2. So more casual gamers get to play in the western sandbox while fans of the narrative know how to balance main/side quests.
For 2077, I agree and hope CDPR uses their own example. Witcher 3 had the best pacing I'd seen in any game by optimally scaling the level requirements. If you stick to the level requirement script, you ended up doing a main quest, a few sides, maybe a couple of contracts, then back to the mains. I always felt as if I was experiencing the game exactly as they intended, while still having room to pursue whatever I want. If 2077 just does that again, especially with a more detailed open world, I'm in for all of it.