Thanks for the reply Fendervg. The water ingress builds up over time and travels down between the door seal and the a pillar trim.
I've just put a hose over the roof and sunroof to try and get a better idea of how much is coming in but it the amount of ingress doesn't change whether it's a lot of water passing over or a little amount of water it always appears to be the same amount.