(G) Water Leak into passenger footwell

After months of struggle found the source of the water leak. The water coming from the joint underneath the wing.

do you have a skyroof check the drains
also i would be more worried about that tyre, its way past illegal
the air con unit also has a habit of becoming blocked, on the pas side there is a right angle hose that drains the air con unit. if that blocks it spills into the foot well.
remove the pas side centre console cover and pull the hose of allow to drain and put a simpe drinking straw in there, this prevents a vacuum occuring and allows it to drain.
change the pollen filter as if this is blocked the airflow will be low and freeze up the matrix causing a build up of water.