Given I am a new player and not very experienced, the skills checks seem annoying and pointless. Like, ok I have begun upgrading Body now. But every time I need to open a door by force (and no Tech option), it's always asking me beyond what I have given to Body attributes. It keeps pushing it up higher....really odd
Yes, the current skill check system is not very good

At first, skill check was added to the game to reflect an important system of tabletop games, the source material of Cyberpunk 2077. Meaning that for most of your actions, decisions, you need to pass a check (dice rolls) more or less difficult depending of your skills level and other factors (a bit like in cRPGs. Baldur's Gate 3 if you played it).
Before 2.0, each areas were leveled which means that every areas host enemies and skill cheks according to this level (Watson low level, low level enemies, low level skill checks / City Center, hight level enemies, high level skill checks). Because of that, you weren't able to came across hight level skill checks because the enemies would have destroyed you right away. So you were almost always encounter skill checks more or less scalled to your level.
But now, since 2.0, they introduced enemies level scalling. It means that enemies are always at your level (more or less) and you're able to visit all the areas no matter your level. For exemple, now you can visit City Center an area formely at level 30-35, at level 10 if you want, while before you couldn't because enemies would have kicked your butt.
So they had to somehow, find a "trick" to keep the skill checks revelant and scalled to players level. Because without it for exemple, at City Center you would have came across only high level skill checks (level 15 and above) and likely succeed at none if you visit the area too early. And at end game, at high level, you would have been able to pass most if not all skill checks on the map...
So yes, the current system is not good and more like a bandaid on the skill check system which wasn't intended to level scalling... But I have no doubt they will rework the entire system for Orion, the next Cyberpunk game, because well... currently it's not good and a bit odd.
Sorry for the wall of words
