Yeah, I think my exploration of the design space is different to other people who are using CH to e.g. store event data.

If you can eliminate most "rows" with criteria on materialized columns, then the occasional dip into JSON shouldn't be too bad.