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.