I have a pretty deep "smart home" setup and it's all run locally from a laptop in my closet with Home Assistant OS. I have run into 0 limitations. All my devices are kept on their own dedicated Zigbee mesh and/or network separate from my LAN. Only way to communicate in or out is via Tailscale. It's incredibly easy to get started too.