Go with used & refurb business PCs right out of the gate instead of fucking around with SBCs like the Pi.
Go with "1-liter" aka Ultra Small Form Factor right away instead of starting with SFF. (I don't have a permanent residence at the moment so this makes sense for me)
Just get a used ultra-small form factor PC a la the Tiny, Mini, or Micro series. A higher-end one which is 7 generations old will still absolutely destroy the Pi in terms of performance.
Once I gave up (for now) on doing all this on ARM and switched back to x86, everything got way easier to actually accomplish.