Thanks @EstebanBustamante for the insights and yes you covered most of the important considerations.
If client is in Adobe Experience suite it might make sense but if a client is on custom infra and looking at AEM as Content repository, I am not sure how much it make sense to move to cloud.