Hikvision has probably been the best "all-around" camera, but they may be subject to import restrictions.
Axis is very good (but un-cheap). Bosch is crappy (and also un-cheap).
I have a Dahua, which is quite good. I also have a pretty good Panasonic.
Funnily enough, probably the most reliable camera that I have, is also the cheapest. It's a $40 FLIR "eyeball" camera (not an IR camera -it's an OEM Chinese camera that several manufacturers rebrand).
A bunch of my cameras are obviously just rebrands of the same cheap crap. The software is abominable.
yeah they have a login wall without a reflash, but most of them do -- but the hardware isn't bad and you can keep it local after setup.
That said -- yes : hikvision is the de-facto generic IPcam without issues. Most CCTV softwares are built around hikvision cameras and firmwares as generics.
(But they are on a VLAN without internet access.)
We got the Duo Floodlight PoE for reference.
Ended up with a pair of reolinks for $120, the spec was a bit less, but I got two cameras. I pointed them from the top of my garage door to both sides of the car, which doubly illuminated the driveway. The red illumination rings on the cameras were easy to spot from the sidewalk, hopefully preventing another attempt. The image quality was great, color during the day, B&W after dark. Ended up using it surprisingly often. Deliveries, kid pickup/drop off, mailman, identifying whatever big truck was visiting our dead end street, and ended up seeing more wildlife than I expected. Even at night I could clearly see the black seat belts inside a black car with a black interior.
I run a separate network for the camera so they can't talk to anything buy my server, so I'm not particularly worried about their network security and I like that the cameras are PoE and not wifi. Sure open source would be better, axis is decent on that front. They run a linux distro, you can ssh in, and even modify the linux distro with an overlap to customize it however you want.
Excellent in Lowlight and has a configurable floodlight.
Also mega-wide field of view