Know what you want it for
The main distinction of the cameras is the connection: ethernet or coax. The networked cameras take power over ethernet and can be connected via a switch. The coax cameras need power injectors (power cable is molded to the signal cable) and a port each on the DVR Lorex's choice of PSUs used to be poor. (One is supplied per 4 cameras. They degraded within a couple of years and caused signal interference. Luckily, they used the same size power plugs as Linksys did for their SoHo switches - I had a truckload of those.)
Decide on that and the rest of the equipment follows suit.
IIRC, our unit had 1080p cameras. That was fine for our indoor application. In general, daylight cameras are no good after the lights go out. Even with LEDs in the bezel, it becomes near impossible to make out anything useful. Night vision cameras in turn have their issues in daylight. (Cameras without IR filters have a red cast, amplified light cameras blow out, ...)
4K video takes up 4x the space as 1080 so if you do get 4K cameras, get a correspondingly larger HDD. (16 motion activated 1080 cameras in a place that was active from 5AM to 10PM filled up 500GB in ~ 3 days.)
The doorbell cameras have two-way communication but they come with an Alexa tie-in and I can't say if that is a requirement or not.
https://www.lorextechnology.com/security-camera-systems/N-y3hmf0Z2o0h5aZ1k4k1skZ9ei7q9Z1wtg35h?Nrpp=50This list narrows things down a bit based on the preferences you listed. (Network cameras as I think the system is more flexible and less bulky than the coax setup.) Most cameras can do 30fps - that also eats storage.