No Camera Found in Scene error message, when clearly there is a camera. Why?
Solved the issue. I had created a second scene where I added a separate HDRI to use in the compositor for some fun effects. Apparently all your scenes require a camera no matter which scene you wish to render.

So once I added a camera to the second scene, the camera in Main Scene finally worked.