I never wanted a moonroof. But my last car came with one standard. I decided I like it tilted a LOT. but never 'open'.
They are OK.
The main thing is a moonroof is always worth it's cost on resale.
You get back nearly what you paid for one when selling the car.
People want them.
So my Focus came with one again. No problem.