So after having the same problems with water leaking into the cabin intermittently, I snipped the drainage tubes, but yet still had the leak.
So I removed the passenger side A-pillar and found the problem. The tube is bent where it turns to go down the A-pillar. The bend is clearly severe...