hi, where to start,humm,
if you are anything like me, anything with write code and script, is a no no,
but the art is find equipment that other people have used to do what you are trying to do, or brands that
have a common platform that will work together,
like onvir, nearly any onvir camera will work and onvir nvr, out the box, well nearly all, i have had tissue with that too
not sure how you planning to home assistant to show image, i have found rstp stream source code one in user manual for my camera and have also used onvif connection, but not all equipment brands these details easy to find.
you could get a dvr and collect you stream from it, if you one same brand with say hdoc thay should work together
you should able to find hd over coax camera (hdoc) and some even power the camera down the same cable, 4mp camera are not dear, there may other format ,ahd, hd_cvi, hd-sdi, all have one basic, video down coax wire, but must be match some don’t fit others, so maybe buy all one brand that way it should be good, look them up to see what suits you,
which will save you replacing cable run if costly,
i dont use camera system in a box, with say 4 camera and recorder, with pre made cables, thay only suit some installations, same light issue, and 1 part stops work and end replacing the lot. Again !!
really !!, as bits get discontinued quickly, or different brand will not mix together.
as for camera choice …well i have work on alot of cameras, and back ground light and what you wanna see is the key,
some brand may state 20mtr infra red night length, but in pitch darkness its more half a metre,
so if you can plan your lighting for outdoors or fit more ir lamps if needed or get cameras with a good name/tech support,
i hope this help sorry for long story, but alot to cover