Let's take a moment to remember the time period when everyone had to adjust to using dual-joysticks on controllers.
(media.piefed.world)
Inverted Y works for me in first-person games because I equate the tilt of the stick to tilting my head. If I want to look up, I have to lean my head back.
In 3rd-person platformers, it's because I'm imagining moving the camera. It's also why I have to invert the x-axis on third-person platformers.
3rd-person shooters I just treat as an fps because that's how my brain works.