Normal feels like I am controlling the vision frustum (where I want to look at), and inverted feels like I am moving the camera itself, as if it was a physical object. I can play both but I definitely have to remind myself what I am trying to control when making the switch.
I vastly prefer non-inverted, because I like the idea of just pointing where I want to look at. I hope it makes sense. All of this apply mostly for games with orbit camera.
I have the impression that being “good” at the game wasn’t even a concern back then. I remember a lot of players being completely unbothered about their own character levels and wealth. Players were busy building communities and driven by small and personal achievements. Sometime I wish gaming had remained niche and never reached the masses. The early 00s was such a sweet spot.