What I saw of it, especially some years ago, was it was highly particular, and everyone had their own odd habits built around running it, ingestion, querying, everything, to the point I suspect there are a non trivial number of companies using it where it is actually the core operational expertise of the company, despite them all appearing to be in totally different domains.
But given the majority of use-cases of CH, AWS can be quite expensive.
Disclosure: My company Altinity offers BYOC management of ClickHouse.