The AIO docker compose container is far better, and I've run Nextcloud in pretty much every installation path in the last decade, using baremetal, my own docker, snap, NCPi, and VMs. All of them have had issues with updating, backup and the host going sideways for some reason or another. The AIO has been flawless for far longer than any of them managed.
You are 👍, next cloud needs like 2 admin per each user. The snap version works fairly well even after a lot of virtualization layers.
Proxmox -> Ubuntu LXC -> Snap -> Nextcloud
I can't say I agree. BSD isn't widely used or supported and the jails require manual setup and maintenance. Meanwhile docker compose and other container runtimes are well supported and can easily spin up and down environments based on a declarative configuration.