You should provide examples of either better or cheaper to substantiate your claim.
According to https://issues.apache.org/jira/browse/CASSANDRA-8844: CDC seems a lot less capable than Kafka:
> Cassandra would only write to the CDC log, and never delete from it. > Cleaning up consumed logfiles would be the client daemon's responibility
on the other hand there is the Cassandra CDC Kafka Connector, that seems to do some work...
in the i still don't see why i would want to use Cassandra over Kafka for storing data, when i care about durability and streaming of append only data.
Postgres, Spanner, etc. come to mind as options if you need to store critical append-only data and also have it be queryable in real-time.
Or use a durable unbounded solution like Pravega instead of Kafka? https://news.ycombinator.com/item?id=20059006#20062821
edit: this could be problematic especially when data privacy laws are involved. See the comments from gopalv below.