Can everyone clean deep with upright back?

Seeing various arguments online not sure what to believe.

Some people say it can be improved. And anecdotally I can attest my upright squat has improved, but now it seems like I'm hitting a wall and going further down while maintaining upright back make my inner front hip feel like it's going to get teared in half.

And this brings me to the other argument which is that some people just have sub optimal hip socket which makes upright ATG squat position impossible.

So which is it? Should I keep going through the pain?

Also, if not everyone can squat upright ATG, does that mean not everyone can go heavy on oly lift since you will either tip over or your hip will get crushed 🤔