I'm curious about what you're issue was finding cameras as, to me, that's the easiest thing to find cloud free since they have a long history of being used in closed networks as POE, onvif cameras long before smart homes were really a thing.
I can’t speak for OP but usually the issue with #3 for me is that the other criteria it needs to meet is that it works with whatever other integration I want. I remember when I looked the TP-Links were a good option but you just needed internet to set it up. Afterwards it just went on a vlan without internet. The camera needs to support Scrypted/Frigate for my use case but depending on needs for PTZ, Wi-Fi, resolution, night vision, etc, I may or may not be able to find one at a reasonable price that doesn’t require internet access for setup. TP Link makes good cameras at a good price but they require internet access to setup, so any camera that falls into #3 will get compared to a TP Link in #2
Agree, I buy some Dahua POE cameras, It can be configured via browser locally with powerful AI feature, and work without internet access, although some drawbacks:
# Some of them are limited to 25 fps
# The model name are really a mess
# Some models are without hardware reset button, the only way to reset is register device to Dahua's cloud service with China phone number (although it is not enforced)
