Been out to the car today to try and work out where the leak is coming from, I have found where the leak is present in the car but it's still unclear where the entry point is. I do think the the bolts that holds the light cluster in place are the culprit. The leak does happen on both left and right sides although the leak inside the car is in slightly different places as shown in the pictures.
Having pulled all the lining out I am surprised just how poorly finished the panels are, they don't fit properly and have sealant plastered all over them. I'd be interested to know if this is the case for other Micra's or perhaps mine has suffered rear end accident damage? The right side light cluster mounting hole is damaged, I only noticed this today as the black plastic crumbled away, therefore this may be leaving the light cluster just loose enough to allow for a leak (also in the pictures). Consequently this bolt appeared to have more rust deposits on the thread suggesting that water may have been getting in here (see picture). Also this mounting point isn't totally flat, it's slightly raised so the light cluster body would have been affected by this and it's this that has possibly caused the housing plastic to crack.
To bodge this fix my options, short of ripping the whole back end off (not feasible), is to try to isolate/seal the bolts and create a rubber seal between the housing and the shell of the car. So I have taken some old bike inner tube, double sided tape and created some washers for the four mount holes. This might also help seal where the mount hole isn't completely flat. Finally I have used some thread lock/seal on the bolts.
If it still leaks then it's coming in through a seam/seal that I can't see or get to which will be very annoying.
The right side leak (directly beneath the light cluster bolt holes)
The left side leak.... it's very mucky on this side, possibly from sealant and spray?... the leak is slightly further over from the leak on the right side.... I'd say this is more in line with the bulb in the light cluster.
Slightly buldging/rusted mounting hold:
Mucky external seam on the right side behind the light cluster, but I cleaned this up and it looks OK to me:
The bolts don't look great and there's evidence of the threads rusting, I used some threadlock the other day but should have put it further down the thread:
My bodged inner tube washers:
Then I realised the housing was cracked, there's also a small hairline crack from the hole outwards (6 o'clock position) thats is only noticeable when it's tightened up:
From the back, I can't really work out what has happened here, the plastic just looks to have crumbled away?