Are certifications worth it while job hunting? after 8 years as a security officer

I saw that many postings ask for a specific certification. I worked as a security officer before this. I would like to use funding if possible. Which ones are overrated?

A hands-on course with a project helped more than a purely online one.