We had a few rains here on the Gulf Coast and the sunroof started leaking. Dealer inspected and decided to replace the sunroof under warranty. Glad it happened before 36 months. I have not checked what the install looks like yet.
I stay away from vehicles with sunroofs. I just replaced my wife's seven year old Explorer with a Tahoe. Closest LT I could find without a sunroof was three hours away. Off we went to NJ to test drive it. She liked it so we brought it home.
In my mind, sunroofs are like skylights. Sooner or latter they are going to leak.