I'm old enough to remember when my company had everything on-prem (both analytical and operational databases and servers) due to cost and security concerns. Nowadays we have everything on GCP.

The biggest problem we had with on-prem was maintenance as it took a lot of staff and time to ensure decent reliability.