You want it all
I do not think you will find a camera with all of that. Especially the reliable motion detection you mentioned earlier as a wish. I have setup a few of the Reolink solar wifi cameras for people that do not use home automation, as they can be installed in minutes without power or cabling. These have a delay between when the PIR motion detects motion when it powers up the camera before they can start recording. The older range was worse then the newer models for this delay, and in some cases if you walked quickly through the cameras feild of view, the camera completely misses the intruder in the too late recording that it takes. On top of this, the battery range from Reolink DO NOT HAVE THE API nor ONVIF.
I would drop the solar/battery requirement myself as this will open up more possibilities as having to save battery power is going to mean compromises on top of not many companies make them probably for this reason. Also POE I feel is better as you can run the cat5 yourself and do not need a power point that requires an electrician to install.
A lot of their newer cameras now do not have the API built in, they may be phasing it out… You need to confirm that the model you want, does or at the very least has ONVIF support otherwise you will just have a generic RTSP camera with no motion detection unless you use FFmpeg to create this for you at the cost of cpu on your server. The FOSCAM api was polling and not event based like even basic ONVIF cameras have.
Annke cameras are made by Hikvision and contain their API in them and sell at a lower cost:
Annke Firmware to Hikvision Firmware: HOW TO | IP Cam Talk
Amcrest cameras are made by Dahua and contain their API in them and sell at a lower cost:
Instar are cameras that contain firmware written by the German company and have a good API and ONVIF so are not the same as the Chinese companies if you are looking for a more trustworthy company. Excellent support and the cameras also have MQTT in them.
Reolink API support is waiting in a PR for openHAB 4.x at the moment.
Most people do not have issues and do not bother to post what model they have working. Most of the brands mentioned above work so long as you stay away from battery and take extra care when choosing any doorbell styled models.
By sticking with a camera that has good support in the IpCamera binding, you can cast the video to google chromecasts, android TV and Alexa devices all locally and no cloud. I also can cast an auto rotating feed of my outdoor cameras, and if any of the cameras detects motion, it jumps to this camera on my TV.
If you want to know if a camera has good ONVIF support, just do a search on www.ipcamtalk.com