The ArcGIS Data Pipelines Connector in Power Automate is great! I am certainly going to implement it. However, it is a band-aid solution for users like myself who execute data engineering at the enterprise scale and use Azure Data Factory / Azure Synapse / Microsoft Fabric for orchestration (and more). Power Automate was a great first step but I cannot version control it nor have it as robustly tested nor publish changes across environments like I can for my Azure Synapse environment for example.
I believe this is also a great idea for implementation because it would help delegate some of the more complex aspects of data engineering like orchestration and even logging to other third parties like Microsoft. There are other open ideas requesting some of this functionality already like logging. Customers who need that can use an orchestration tool from another third party and allow Data Pipelines focus solely on geospatial data engineering within the ArcGIS ecosystem.