re-patriation - the process of moving back off the cloud to on-premise - is gaining significant momentum. The cost of the cloud hosting is not so much as issue, as the cloud provider's liability on data loss, typically constrained to the last months hosting fee. So if you have a "business extinction event" the hosting company refunds a few hundred bucks. Thanks loads.
I've had Macs running as FMS machine without intervention for a 10+ years. If you want to keep up to releases, you do have to upgrade both OS and FMS regularly, but unlike the Microsoft weekly "Patch Tuesday" that is both risky and a time sink on Windows. Macs and Linux boxes are lower support costs.
For on premise, a local DNS server is almost mandatory (over editing etc/hosts files on every desktop). NAMO is a $20 DNS option for MacOS that I have on all my on-premise MacOS FMS boxes. The router DNS table points to the NAMO/FMS IP address and FQDNs resolve internally.
If you are downtime concerned, Mirrorsync can keep two FMS machines in near real-time sync ($1600).
Control of external storage is far easier on on-premise solutions. Cloud backups are all well and good, but time-to-recover over a WAN connection can take a company offline for many hours/days. Local storage is faster, but it would still be prudent to have an offsite storage, in case of fire/theft of the on-premise equipment.
Also of note; most cable based broadband connections are asymmetrical - fast down, slower up, so hosting on-premise with external users can be a performance bottleneck.
Also, static IP addresses are often not offered, or offered at a premium. Using a service like DYNU.com's free DDNS service is a solid workaround to avoid that cost.
Port forwarding and associated rules on your in-house router is also needed for external access. Alternatively you can install the free-for-25 connection ZeroTier product and provide VPN like services without dealing with router configs.
Another great option: host your own mini on MacMiniVault for $50 a month. I've got a few servers there, and they are pretty awesome. The $99 a month they want for a firewall is exhorbitant, but using MURUS on MacOS, allows extreme control of the vary cable PF firewall built into MacOS.