If you park under trees, the drains will eventually clog. Especially pine trees. A little bit of periodic drain cleaning will go a long way. Every other time you wash the car, blow some canned air through the drain holes. Should keep you leak free.
That being said, every car I've ever owned has had a moon/sun roof and I've never had one leak.