Wyze Cam v3 or Wyze Floodlight Cam v1 (both rated IP65) running open-source Thingino firmware. These can be used by pretty much any NVR software running on a cheap off-lease office PC (Dell Optiplex or similar).

I'm in the process of figuring out my own NVR solution with Frigate. I just bought a Wyze Cam v3 this weekend and immediately flashed it with Thingino as a proof of concept, mostly for myself. There's lots of functionality, including the fact that it can still record locally to SD; all I need to do now is figure out how to replicate most of Ring's functionality within Frigate and HA to meet the "wife approval factor". It helps that she's already 100% onboard with HA, so that's pretty nice.

Home Assistant already offers remote access through Nabu Casa (everyone using HA really should consider subscribing, it all goes towards financing HA development), and with the Frigate integration, the cameras can be remotely managed as well (I think... I should check that).