This would imply the X axis has to be inverted too...

For me I only accept inverted camera controls for orbiting cameras that aren't use for aiming.

Its two different perspectives. One is controlling a character as if they are controlling a camera from the rear. The other is the more common, where you're using the joystick to move the point that you're looking at.

This is so silly. Thanks for making me laugh.

Am I a weirdo to thinks about turning my head to the left, not the back of my head to the right?

This doesn't seem intuitive

You're right, but somewhere along the way we all got used to the other way

The first time someone explained this to me and showed me how to invert controls, it changed my life and made video games more enjoyable (I'm mostly a PC gamer out of convenience but prefer a console/controller). I recently played the ff7 remake and forgot that I could invert controls and was about to quit playing until I remembered I could invert. "Standard" controls don't make sense to me and kinda make me dizzy or seasick.

If you just imagine that the right stick is their neck you don't need to postulate a Parasaurolophus horn