I am looking for a camera with
A camera that I don’t have to modify it’s firmware to get it to work and no cloud integration.
I am ok with the 2 way audio working only through the camera app (it’s a nice to have feature but not a must). The RTSP stream is for using with Frigate for motion detection
Have you looked at the tapo cameras Security Wi-Fi Camera | Tapo) and the tapo camera custom component ( [Custom Component] Tapo: Cameras Control - Share your Projects! / Custom Components - Home Assistant Community (home-assistant.io))?
They definitely support all the above functions in the native app. the only thing not currently in the tapo integration for HA is 2 way audio. appreciate that doesn’t quite address all requirements but hope its helpful.
I could only find This one for outdoor but not available in Amazon Canada. Have you tried it ?
I am also looking at this one which has RTSP and ONVIF