This is exactly what I needed to hear. Never had a moonroof and was concerned I may have been asking for problems with all the negative opinions I have found but this kinda balances it out.This is my third Ford with the panoramic, vista view, multi panel moonroof (or whatever they call the big assed moonroof). My wife's car is a 2017 Explorer, with the big moonroof. My old truck was an '18 Raptor, with the big moonroof. And my Tremor, yes, it also has the big moonroof.
Prior to the Explorer, we had a '01 and '03 F-150s, an '03 Mazda Protege5, a '99 Explorer, a '98 Contour SVT, and a '92 Taurus SHO. Each of these earlier vehicles had the normal sized, not so big-assed, factory moonroofs.
I've never had any issue with any moonroof on any of these vehicles. I accept that it is a big hole in the roof, with seals and mechanisms, which can eventually lead to issues. And that others have seen problems. But I think premature problems are the exception, rather than the rule. And given enough time, everything has an expected lifespan before needing replacement parts. I haven't kept any of the above vehicles past about 15 years, so maybe the lifespan is in the 10-15 year range - depending on care and usage?
tl:dr version: I've had lots of luck. Unless you're going to close the shade, and never open it - I recommend the moonroof!
P.S. Thinking about it, this is sorta crazy. Prior to that '92 SHO, I had a Firebird with T-tops. Prior to that, a '67 Chevy pickup and a '67 Bronco. That '67 Chevy was the only vehicle I've ever owned that didn't have some form of removeable roof'age or another.
A friend of mine with a Raptor was pulling off his rack with a pulley system he has in the garage a couple of days ago. It's worked well for years. As he was pulling the rack the pulley came down with some 2x4's and shattered his sunroof............I didn't want a moon roof for fear of dropping a ladder, canoe, kayak, pole saw, etc while loading it. I was only looking at King Ranch models and really struggled to find any without the moon roof. I think they look really cool, and if it was a car I would have done it, but since this is a truck and I have eventual plans to use it like a truck I decided to order what I wanted without the moon roof.