I have a poe managed ubiquity switch and use reolink Poe cameras and reolinks Poe doorbell. Home assistant has great support for reolink; It’s also local. I have home assistant save the streams on motion detection to a network mounted drive in home assistant
Well worth running Poe if you can. Poe can also power some wifi access points(I use ubiquity sps I bought cheap on trademr), so you can hide them in your roof space.