My Reolink cameras are firewalled from communicating with the internet, so I can confirm that they function fine without cloud access.
homeassistant
Home Assistant is open source home automation that puts local control and privacy first. Powered by a worldwide community of tinkerers and DIY enthusiasts. Perfect to run on a Raspberry Pi or a local server. Available for free at home-assistant.io
Happy with my Reolink RLC-820A cameras. 4K, powered via PoE, and no dependency on cloud services.
I have mine configured in a Frigate docker container, recording to my NAS.
Another vote for Reolink.
Be aware that for initial config of each camera, you need to run an app (windows, iOS, android, I couldn't get it to work in Wine), or craft a QR code containing network information.
Also be aware that their 4K cameras use h265 when at full resolution, which isn't supported by a lot of FOSS due to licensing costs.
I was able to config mine by finding it's IP address and going there with my browser. Haven't needed any app yet.
Roelink (wired) as others have said, Amcrest is also good. Have a look at The Hook Up on YouTube for reviews. He does only comparative reviews and local control is one of his most important metric.
Adding to this as I'm also interested. I'm currently looking at cameras recommended in the Frigate wiki, since any camera that works well in Frigate also ought to work well in HA. One interesting thing I've noted is that some of the Hikvision and Dahua models have onboard AI features for object recognition. Does anyone have experience with these? Can they report these events back to home assistant and are they worth using?
I have foscam cameras and have been pretty happy with them. Regardless of the brand, make sure you firewall them from the internet or they will phone home.
Reason I went with foscam was because at the time they were the only brand with an outdoor PoE camera that had a spotlight, 2-way audio, PIR, and ONVIF support. Which was what I wanted for an entryway camera. They've since discontinued that "SPC" model, so if I had to do it over again I would be just as likely to pick reolink (had shitty luck with amcrest).
Reolink should be good, they support ONVIF for control, and some models come with ethernet. They offer some cloud stuff but you don't have to use it.