Not sure about wifi cameras, I have a mix of Trendnet and Hikivision POE, sitting on a Vlan with no internet access. For the software I use Blue Iris. Where I have a need for cameras I have only a Windows server and I have found this software to be the best for me.

Yeah Lenovo tinies ares great I have a bunch of m910q’s I use for everything

In my town they fill up at co-op Cardlock, same as the truckers but gasoline instead of diesel

It’s what I use to remote access to my Starlink network. Have it running on a little Linux box, and publishes my internal subnet so I can access any device on my network with Tailscale running on just one PC.