I love my 3 POE reolink cameras, they are all local and just joined Home assistant officially. The integration is flawless and love that I don't have to use frigate either. I have all my cameras recording directly to my NAS via FTP.

Not sure what your current skill level is, but an IP POE intercom with the ability to initiate SIP calls is probably the most long lived way to go.

BAS-IP, Aiphone, hikvision and a few other manufacturers have them at various price points and quality of construction.

You would need a SIP connector or something into HA to make use of it, like I guess you would want to flick on a light when the doorbell is pushed after dark?

https://community.home-assistant.io/t/sip-doorbell/340798

I didn't look into how well this works, I'm using the first party app for my video doorbell and I don't have anything integrated into HA right now.

@gedaliyah A related question: We have an alarm.com installation, and I would like to know if it is possible to reuse their hardware on home assistant, or if that's just too proprietary to use for anything. They are all wired.

why do you want a camera doorbell? in any case I'm interested in your response.

I recommend to not have any cameras that record public areas. personally I hate doorbell cameras. who the fuck knows where will the recordings end up, but it's almost 100 percent they won't stay locally.
old ones that don't involve modern tech, even a network cable, are.. fine? but again, how do you tell them apart. and it's not only about the doorbells.

these are cameras that record public area, even if just those who pass by on the street. owners of these are basically letting tech companies snitch on their neighborhoods. where I live these are illegal, but of course lots of houses use either cameras disguised as doorbells, or even install their fucking cameras on the outside of the buildings and being pointed to the didewalk and the road.