Is Microsoft Backup Reliable for General Use and Ransomware Protection?

I'm running a small business with around 200 users, and I'm managing most of it single-handedly. We're setting up a new company; part of it is from scratch while the other half came from a recent acquisition and is gradually integrating. I've built the cloud infrastructure entirely on Azure/365, meaning no on-prem servers to maintain, which I've done for years. I prefer letting cloud services handle things while I focus on using them. However, we're still dealing with an on-prem server for file storage for some departments, which has been challenging, especially because some users want to save files in places that OneDrive doesn't sync. I've warned them that if they lose files, it's on them. Microsoft OneDrive and SharePoint are decent, but I'm aware that they need backup solutions, particularly against ransomware threats. I'm curious if the Microsoft Backup solution is trustworthy enough because it integrates smoothly with the Microsoft ecosystem, but I've read mixed reviews about its effectiveness in recovering from ransomware attacks. I have about 100GB of data across Exchange, SharePoint, and OneDrive, and expect that to grow to around 1TB in a few years, depending on our data retention practices. My budget is flexible, as I'm willing to invest in what's necessary. Given that people will use OneDrive, we've got the accidental deletion covered, but I'm primarily concerned about major recovery situations. So, is Microsoft Backup reliable, or should I look for another solution?