Glossary:Invert Y-axis
Presented in order of release.
Spore
In its second stage (the 'tribal' stage), you cannot adjust the y-axis inversion of the camera control.
Silent Hill: Homecoming
A good account of lack of y-axis inversion is available here
Myst V: End of Ages
Beyond Good and Evil
The option to invert the axis will invert-y, but also invert-x as well.
Prince of Persia: The Two Thrones
Reports state that whilst the y-axis inversion option exists in the settings, the implementation is bugged and has no functionality within the game.