I've recently implemented a map of the Internet using a similar technique: https://reversedns.space/

In ClickHouse, we have almost every mentioned technique: H3 and S2, geohashes, and indexing by space-filling curves.