Hey @arkiboys ,
ADF is basically similar to SSIS wherein you have components inbuilt and you drag and drop and create flows.
Whereas ADB(databricks) is completely code oriented wherein even to connect to source or sink you would need to write a code or to do a loop or iteration whereas in ADF it is a matter of creating a linked service directly and using For each loop.
ADF is still an evolving tool so there are many scenarios which cannot be handled via ADF for which you need to write a custom code (there you can leverage Azure fucntions, Azure batch,Azure automation or databricks)
So based on use cases, we take a call whether to leverage ADF or ADB