Do you know where it was coming in?
The water came in the most on the passenger side and it was dripping down to the carpet and around the left speaker. Talk to the factory, they said the door hinge will have to be adjusted. But there were drops dripping at a few places from the front windscreen too. It was not that much. To be fair it was raining more than a fair bit on the M5 on the way down and I was cruising at 80, at times went up to 95-ish when passing. That was when the water came in the most. On the way back it did not rain as much and very little water came in through the passenger side and none in the wind screen. I don't know how they would solve the windscreen issue. Perhaps when it gets warmer the rubber seal might expand and fit n seal the glass better.
Thank you all for the advises and I'm sure that its going to be ok too. I was hoping that there might be an after market manual hood lock that does not compromise the look of the car. Cheers.