If you're interested, here's how Uber solved it for their internal tooling:

https://h3geo.org/

https://www.youtube.com/watch?v=PutOhe8HVNU