Hello !
The only thing I can add here is migrating from ASA or ADF to dbks can make sense when your workloads need more scalable spark based processing, batch and streaming support, advanced transformation logic, lakehouse architecture or ML and AI capabilities. You have also use photon and autoscaling which can improve throughput and are reallu cost efficiency for the right workloads. However IMHO migration should not be treated as a blanket recommendation because ADF remains a strong choice for orchestration and ingestion and also low code integration scenarios and many people use ADF together with DBKS rather than replacing it entirely. The right decision depends on workload complexity performance requirements, team skills, governance and total cost of ownership.
Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP