I have been sent 2 rear cameras (one with one without cable) and 2 front cameras and still struggled with this. Even bought the high endurance card.
The recent 2023 firmware (on their site, not beta) seems to have solved the issue. Since I had the 2nd front/rear camera I swaped it with my older 1080p camera to try that and this one is reliable too. The notes specifically mention "screen turning on and off" - which may refer to the rear camera turning on and off on the screen itself, maybe.