I do roughly what I’ve described in this post: Internet-accessible Local-first farmOS hosting (Of course this setup is only a good fit if you actually want your farmOS install to be internet accessible.)
TL;DR; Host farmOS on my local network, but use a cloud IP address and reverse ssh port forwarding to make farmOS accessible via the same IP/DNS locally and on the public internet. Then use firewall rules on the local network to reroute requests to/from the cloud IP directly to/from the farmOS server - giving local performance/reliability.