While I like the general thinking, the details I don't. CDC is not done for its own benefit, but to provide data for the consumers.

Example: Having one topic per table gives away all the database consistency for the consumers. Suddenly a consumer has a order without line items or worse, items without the master data.

So all the work has to be implemented by every single consumer.

I have even seen CDC solutions where the consumer just got the info that field A got changed in table 1.

There are better ways to deal with that,