Databricks Autoscaling is useful for interactive or streaming jobs. However, it is less beneficial when the workload is already known, such as in batch processing with a consistent amount of data for each execution.
Here is a great article on the topic: Is Databricks Autoscaling Cost Efficient.