We're still hosted by OVH with automated daily backups I believe. I think we went Texas
> London > OVH France > Hetzner Germany > OVH France
Actually we currently have two OVH servers (both in Roubaix)...
Honestly not sure if our back-ups are offsite or simply in the same facility in case our rack fails. Our server is in a different country sure but that news was a bit surprising to be honest and made me think twice about some off-site database backups at least! Regardless of whatever the host does, if it's going to go and burst into flames that even firefighters can't put out...
Cloud / distributed hosting architectures are obviously very resilient but they are also generally priced "on demand" so if demand goes up, cost goes up astronomically scaled like that. A more traditional data centre is generally cheaper yeah and (in theory) easier to administer, with a fix cost attached to it. So if you more or less know what your traffic demands are, it's often a sensible approach and much simpler.
One neat thing we do have which kicked in for a couple of hours the other day actually is DDoS mitigation, our traffic gets booted to another system that's built to screen every single packet automatically for a time while we're getting pounded with worthless traffic, and then it gets rerouted back to our server again without us having to do anything. Apparently nobody noticed.
Then again there were "isuses" at OVH as you probably all remember and I never got an explanation for what happened. Some router failure or whatever. They credited us about £1 and everyone got on with their lives.