I think we are talking about file events here.
What you are talking about is in fact streaming ingest from a CDC system.  That can be done but not by directly connecting to the CDC.  You can forward the CDC events to a event queue like Kafka etc, and let Spark subscribe to one of those topics.
Mule soft probably works too, but honestly as you already mentioned, it is overpriced.
What is presented here was already possible in many other systems, but is now also added in Databricks.