I decided against a moonroof for a few reasons. Firstly, I live in an area of New England where I see more snow and rain than sun. There's probably 30 days a year where I'd actually use the moonroof. Secondly, while it might not be too common to have leaks, when it snows 100 inches a year or more, I don't want to have to deal with the ice on that window or the chance of snow piling on top of it. While it might not leak now, in 7 years it might.
All in all, I didn't think it was worth the money because of the weather I live in. If I lived south, I'd definitely have one.