Ok so I found several problems. I removed the door cards and they are really bad, all wet. I don't have any plastic on there at all any more. So when I pour water down the window it just runs into the door and then out the door card. Not loads but enough to cause it to leak inside the car.
So can I buy new outer window seals and cure this? The drain holes are clear. I did however find all this sitting in the bottom of the passenger door.

What is that?
The drivers door is completely empty and with no plastic membrane either. So will suck tape up the holes and hopefully cure a bit of it.
The drivers door is also leaking because the top of the door at the front doesn't seem to sit snug. Where the door seal touches the door there's a gap, so water is just coming in and down the door seal. How can I fix that? Without getting new doors lol. Can I try bending the door or will I just end up causing more issues.
Not a very good picture but u can see there's a gap