Sunroofs are overrated. Learned that with my first car that had one. They don't provide that "open air" experience IMO. My current car has one, and it's been a little leaky - not ideal in western WA. Seems to be fixed now heading into spring, but still. I bought the car in spite of the sunroof, not because of it.
The leaks were due to clogged drain lines. Got a little water in the passenger compartment, and a lot in the trunk - like an inch of water in the spare tire well. Was able to clear them with some help from YouTube. Love the car other than the sunroof. (2009 Cadillac CTS, 3.6L 300hp, 130k miles, bought last fall).