(disclaimer: I work at ClickHouse)

Another important dimension I'd consider as well is the broader ecosystem of integrations. In OSS, it's a byproduct of the success of the main project but an often overlooked aspect when choosing a solution.

Eg. Here are some of the Kafka integrations options for CH https://clickhouse.com/docs/en/integrations/kafka