It depends on both what you are optimizing for. People cost money. If you can trade enough of your time by having a cloud provider do the “undifferentiated heavy lifting” to focus on your core competency, then it makes sense to use a provider.
For instance it didn’t make sense for DropBox to stay on Amazon but it did make sense for Netflix.