reolink has been my go to camera manufacture.
where you show you want to put yours, I have a ball turret type that hangs from the eve.
it records to my nvr, but I also have a SD card in the camera as well.
it will run POE so I only had to run a network drop to it, but it is a wifi camera as well.
I have a similar one in the back yard that just has power run to it.
it will track vehicles as well.

they also have battery powered and solar powered cameras as well.
phone app lets you view and send notifications with screen shots.

50 bucks up to 300 for camera's.
mine were 150 and 250 for the pan and scan types I chose.
the higher end ones have 2 lens's they shoot from for higher magnification.