The First "FPS" that I played with the mouse was Descent. I played it for weeks. After that I could never get back to Non-Reversed Y-Axis.
Luckily most of the games allow me to switch it. There are only few crappy titles like Neuro Hunter where the developers are too dumb to implement it.