I've gotten used to it, but I never liked it because the direction of movement is decoupled from the direction of the camera. Moving the mouse left and right also swivels the camera around a moving invisible point looking inwards, instead of stationary around the character looking outwards.

Also, is the obstruction you speak of really an issue? Never had I thought "God damn, move over!" to the character I was controlling straight from above-behind in ye olde days.

Camera behind the player is preferable for platformer games where you are concerned about your movement.

Over the shoulder (offset behind the player) was popularized by resident evil 4. It makes sense because you want to both focus on what’s in front of you with a clear canvas for aiming while also keeping the character in view as part of the game.

They are officially developing the Max Payne remakes