Belinda,I sure would be livid (understatement)if this type of leak happen to me.
Possibly I understand more than the average vehicle owner on this type of installation
since over the years I have done numerous body mods to my vehicles.
However,I would not attempt to install a OEM sunroof kit on any newer vehicle.
There is just too much involved.And,significant damage(as you have learned)if its screwed up.
Maybe I'd try to do one of them pop up sunroofs that were all the rage in the 80's on a beater.
Going back to your original message,you stated that the sunroof closes "automatically" when
the vehicle is turned off. Are you sure? Maybe this is the source of the leak.
I'd think there should be adjustments in the mechanism available that allows the roof
to seal tighter(or looser).The comments about the drain tubes are valid. Where does the water go
if it is trapped in the recesses of the sunroof tracks etc.? I'd check that auto-closing seal first.
As mentioned,doing a sunroof install is not for the average DIY'r. You have to accurately measure the position
of the unit on the vehicle. Should be a template supplied. Removal of the headliner or at least part of same.
Proper panel cutter for the hole to be cut.On a OEM unit,proper wiring,switches along with all associated
trim to make the unit look like it came on the vehicle.
Not easy stuff.
As mentioned in my previous post,I went through a similar sunroof install on a car I was buying for a daughter.
It was a Mitsu. Eclipse. I was in a "just had to have" situation with the daughter. I negotiated with the dealer
on the sunroof as,needed it. Or,it was a deal breaker. The dealer obliged at a reasonable cost. He shrugged
and said the install was no big deal.They did them all the time. They sent the car out to a specialty shop.
I'd get it back in two days. I did. I was amazed on how good the install looked.
When it looks right,it looks like it was on the car in the first place,period.
It worked great. It never leaked.
All was good until the daughter wrecked the car several months later.
Lesson learned.Never buy that type of car for a teenager.
Think practical. Don't purchase heavy on being cool.
Buy a Soul.