I saw the same video, and had the same thoughts. I saw a comment mentioning flashing the Emporia with ESPHOME, of which I am a great fan. What I really like about that option is you can push all the logic to the "edge" device with ease (including hosting a webserver), or just merely expose the data and use e.g
homeassistant to manage it. I'm sure you could probably also have it post the data directly to clickhouse if you want. All this to say esphome is really great and I love its flexibility.
I was planning to build something similar with esp32 until i found the emporia.
It's a bit of a hassle to install (don't think anything can be done about that) and I didn't really like the official ui, but it works great with home assistant / esphome. [0]
Several comments on that video say it can be Tasmotized. It runs on an ESP32.
Amazon’s got them for $165, and that’s with 16 circuits plus the main.
[0] https://youtu.be/siJZYFCmU68