I've tried most configurations.
I have 2 favourite combos.
Both involve using proxmox.
1- frigate on proxmox lxc (debian 12 lxc with docker/portainer) with openvino model (no tpu required), or with the pcie tpu - with HAOS on a VM in proxmox. With the addon 'Frigate Proxy' and also the hacs frigate for all the controls to put on the HA dashboard.
2 - frigate on proxmox lxc (debian 12 lxc with docker/portainer) with openvino model (no tpu required), or with the pcie tpu. - with HA on a docker lxc (no addons). any other containers like nodered etc I spin up other lxc containers. really easy.
Proxmox is so easy to backup up, restore, migrate etc.
Plus you can have a 3 mode cluster, or 2 node and qdevice for quorum