Hopefully, never. In all of the cars I've owned with sunroofs I can count on one hand the number of times I've actually opened it.
In exchange you get another point of failure, potential leaks, additional weight, loss of headroom etc. Then the wind noise when it is open. No thanks.
I know some people like them. I'm sure there are others in my camp. To each their own.