I posted some ideas and photos of how I used my porch light. Might give you some ideas.
Hard to find, so scroll down to Aug '21. My newspaper box, and porch light.
I extended the camera’s stand, and so it was flat like the face, and used double sided tape to stick a piece of steel inside my non-steel porch light. Then a flat/stick magnet allowed me to push/hold the camera in position and use the magnet to adjust where the camera lens peeks out best through the 5/8" hole.