My 06 had an annoying rattle/shake in the sunroof and I recently got it fixed. I had posted about it before here:
Sunroof Rattle/Movement 2006

Well they greased it up and I guess realigned some moving parts and now it is fixed.

Before that I had a very small leak inside by my driverside door where the headliner starts. It would only happen when I would only go to a car wash where they blew the compressed air to blow dry the car.

Well I wanted to see where that small leak was (I thought it was my door) and decided to record it while my headliner was still removed. And got more than I bargained for. I took the car back in this morning to the dealership and they said the weather seal around the glass is bad and thats why I got drenched.

Is this normal? I was told I had to buy a whole glass replacement for around $600. Is there another fix I can try?

Runner Sunroof leak after repair for a rattle. - YouTube

Based on your video, saying it was bad is an UNDERSTATEMENT! It looks like it doesn't even have one.

That sucks. I recall reading other posts where the only option was to replace the entire sunroof. Some said try a junkyard to find one cheap(er)

Yeah this weekend I am going to check some junk yards.