Reolink. Cheap, good enough quality, great HA integration, no internet connection needed.
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
Amcrest gets recommended a lot but I have no personal experience with them
I’ve owned a bunch of Foscam cameras, a sub-brand owned by Amcrest.
Amcrest and its Foscam sub-brand seem very interested in getting access to your cameras, have less capable and less convenient software, and the cameras themselves seem less well built than Reolink.
I bought a half a dozen V1 Wyze cams, and at least two of them have failed. I won’t touch that brand again. I also would never have used Wyze at all except for the exploit that allowed custom firmware installation for real local access and control.