Hello @arkiboys ,
Thanks for the ask and using the forum .
Azure does offer lot of other services( as you mentioned like ADF, Power BI , synapse , SQl etc ) under the same hood . All these services are connected with the Azure AD which is a big plus when you have many services talking to each other , as far as I know snow flake does not offer that . Moreover you did mentioned that you have a lot SSIS packages , i could like you to know that you use the existing SSIS using ADF in azure . Please read about the same here .
Let me know if you have any further questions .
Thanks
Himanshu