Update: Have been digging into this more and it looks like we're going to switch to QuestDB.

Seems like a solid bet with clear roadmap, pricing and strong performance. Also, looks to be more affordable than Timescale.

InfluxDB was such a bait though - it has potential but unfortunately, don't want to take that risk with our infrastructure.

Thanks for the answers below - was really helpful in making a decision.