Thanks Yendor,
It's not the door lock, I think your last sentence may be the answer.
I've recently plugged a couple of new USB chargers into the lighter and power sockets. I notice they have led lights in them and once the car is turned off it continues to light up as it's draining from the battery on the dashcam.
Assuming that's just enough power to cycle the relay till the camera battery goes flat. Going out to unplug it now which I have been doing most times, but I know it's plugged in now. I'll keep you updated, this explains why it's intermittent.
Again thanks for your advice, always like reading your replies to others issues/questions. Knowledgeable and always helpful.
Cheers mate