I am working with Moodle just a little bit currently. It's not the main focus of my position, but I have been working with it since 2009. I've been doing some side work, and I also spoke at Moodle conferences all the time before COVID. I've done a lot of solution architecture and project management around custom add-ons and configuration with Moodle.
Its use cases really depend on an organization. When I work with an organization, I look at their technical requirements and their business needs and try to find the best LMS that fits their infrastructure and their business and training needs within their budget. Moodle does fit most companies as an option. So, when it is a good fit, I recommend it to the company or organization.
It is a cloud solution, and the cloud provider depends on the client's needs, but normally, it's sitting on AWS.