I think OSCP was the most legitimately useful in tech https://www.offensive-security.com/pwk-oscp/
PMP has been useful to take on Project Manager roles, but really PrM roles aren't all that exciting to begin with. Still helps when you want to run your own projects.
I'm currently studying to be a certified parliamentarian from the National Association of Parliamentarians. I'm interested in corporate governance and learning Roberts Rules of Order definitely helps.
I'm also a certified farmer (yeah its a thing), I have 5 sailing certs, 3 scuba certs, Wilderness Emergency Medical Responder cert, working on my pilots license, getting my real estate sales license, ham radio operator general class, almost done with my CDL, there's lots more I'd have to check my notes on.
I do want to get a Kubernetes cert done this year. Long term I want to knock out my CPA/CFA exams, but those are a huge commitment so we will see if it pans out.
Most of this response hasn't answered your question at all, because certs really are mostly useless. Still fun to collect.
I'd imagine financial certs would be the most useful (CFA in particular).
If anyone knows any other fun certs let me know.