Ok, so for anyone that has a waterleak on the left side of their car PAY ATTENTION! This is EXACTLY what is going on in my particular situation:
In the pictures below, the yellow highlighted area just indicates that normally there would be an interior trim panel there, but i removed the trim in that area to get a better look of whats going on. The green indicates the path of water out of your view (inside the pillar) or its just an arrow showing you something in the picture. The blue is visible water exiting where it is supposed to exit. The red is visible water exiting inside the car, where it should not be.
Heres a picture of the general left side of my car just in case.
This is the left front corner of the sunroof. To the left is the left side of the car. the arrow is indicating the location of the drainage hole which is out of view.
this is a close up, so you can see the exact location of the drainage hole.
Here you can see where the water is supposed to enter, and where the tube runs down the pillar, and where it is SUPPOSED to exit (water coming out in the correct place is blue). You can also see where the water is entering the car (generally, not exact -- this is in red)
Here is the exit point for the water on the outside of the car. it's under the hinges of the front driver's door.
Another picture that shows whats going on inside the car.
does this better explain what's going on for everyone. i will see massive water leaking in after pouring about a gallon of water into the drainage point and no less. This weekend i will try cleaning out the drainage tube at my brother's work.