You’ll have to forgive me, as I haven’t tested this personally on Linux yet, but this webcam is a USB 3 device and doesn’t have any special drivers. It should work plug-n-play.
The reason I bring it to your attention is that it has a nice physical lens for focusing, aperture, and zoom; all separate. It’s 4k 30 fps and I can confirm that the picture is really nice.
It is much easier to buy one “hefty” physical machine and run ProxMox with virtual machines for servers than it is to run multiple Raspberry Pis. After living that life for years, I’m a ProxMox shill now. Backups are important (read the other comments), and ProxMox makes backup/restore easy. Because eventually you will fuck a server up beyond repair, you will lose data, and you will feel terrible about it. Learn from my mistakes.