I went with Frigate, and based on the maintainer’s recommendations and on what was actually available in Europe, I went with one of the Hikvision models.

Just make sure to completely isolate them from the internet as there are some serious privacy concerns about using them online.

This is not true, TrueNAS will simply migrate vms to incus, along with also introducing LXC support. https://www.truenas.com/docs/scale/scaletutorials/instances/