I ended up ordering the Ubiquity setup, I’m hoping it’s a good balance between performance and simplicity. Sophos XG has been great but I’ve lost hours/days working on it, I think sometimes simpler is better.
I’ll never buy anything by TP-Link though, that’s one very fishy company. Aside from stuff I’ve read online (eg. too much telemetry), I was working on a TP-Link Powerline for a friend of the family years ago and the instructions for pairing didn’t work. So instead I managed to find it’s internal IP and bring up the web interface - only to be presented with a page from BT’s powerline software. It clearly wasn’t intended to be accessed by the average consumer, and I would suspect it was ripped from BT’s devices.
I think the 24p is 12x 1G and 12x 2.5G so I figured I can just route all devices into one and even save a little bit of money on electric (eg. instead of running extra switches, I bought various lengths of the skinny Ubiquity ethernet cables to wire devices direct.)