It’s a year old video, but it still is pretty relevant I think.

Local Control Video Doorbells - Reolink, UniFi, Amcrest, Hikvision, Dahua. https://www.youtube.com/watch?v=6XCu6L0xn4Y&t=904s

If you’d rather read than watch the video, he has a nice companion blog. https://www.thesmarthomehookup.com/local-control-video-doorbells-reolink-unifi-amcrest-hikvision-dahua/

I’ve told my wife and family that if something happens to me, they need to start migrating all their stuff off my self-hosted services to cloud services because its a matter of time before something fails and nobody’s around who knows or cares to fix it.

I’m not sure what kind of money you want to spend? The M2 Hat is ~$14 USD and a 2242 NVME SSD can be had for ~$30-$40 USD since you don’t care as much about performance.

The USB to SATA adapter is going to run ~$10 USD and the SATA SSD drives are going to start ~$20 USD are go up from there depending on size, performance, etc.

If size of storage is an issue, the SATA SSD is probably the better route. I believe the NVME would be better performance since it utilizes the bus on the Pi more fully.

I would guess that for the money, most M2 drives and SATA SSD drives are going to be similar lifespans

Which Raspberry Pi do you have? There are some very reasonably priced M2 hats out there that you can boot from on the Pi 5, including the Raspberry Pi branded one.

What I wish existed was a self-hosted version of OurGroceries.

If you want self hosted, I’d second all the Grocy comments. I don’t use it because it isn’t simple enough for my family, but I did like it.