Here's my .02 for this question.
Pros -
I love the looks, and definitely enjoy having it open, and the kids enjoy it too especially on long drives at night, cool to look out through it at the stars, or during thunderstorms.
Can help during resale if it's in good working order.
Cons -
This is the third vehicle I've had one in. One of the first two definitely had rattle issues, that took 3 yrs and Chrysler engineers flying from detroit to denver to finally fix. After that it was perfect for 5 more years before I sold it.
Not sure they actually help with cabin temps at all, I tend have the privacy cover closed a lot to keep the sun or cold out.
This "maintenance" procedure is kind of a joke. Again, bad materials and craftsmanship make it a pain. In 13 yrs of having moonroofs, this is the first that requires a special procedure and lubricant for the seals. Don't get me wrong, I've always had to clean and lubricate tracks, but never the seals to keep them functional and watertight. I have done the procedure a couple times myself and the dealer has done it once to fix the popping issue (which didn't fix it, they had to replace a track).
I pray every time I use it that it won't foul up, but this is also why I have an ESP.