I loved my sunroof that was after-market fitted to my Corolla RXI.
It was especially useful when I still smoked.
It never leaked, jammed or gave any hassle.
It had a panel that could be slided out under the sunroof glass to "close the window", so that the noon sun does not bother you on long trips, and you could have it open at 12 degree's at the same time to get the fresh air benefit. "Closing it" is necessary, even with the 60% tint on the glass, the sun still packs a punch.
Remember to have some means of closing it (outside the car), realising that the sun-roof is still open after you've locked up is a nuisance, I had mine wired to the remote control to close it.
Of course, it cost a damn fortune to fit, and it has to be properly lubricated every 12 months.
For the extra airiness in the car, it was awesome.
But, for the people who want to stand up through the sunroof, that's a really stupid idea, you get all kinds of bugs stuck in your teeth.