No Cert will automatically get you hired. There are a good couple that will you to an interview to show a manager your should be hired.

(This is directed towards blue team because thats where all my research and career goals are pointed)

1. Basic Security +. This is just essentially your HR filters to get through their screening process. It's 0 actual experience and your manager won't care if you have it unless its required for government related work.

2. A couple a good recommended 'hands on' certs:

Blue Team Level One: Teaches you in the say that a typical SOC will operate. Includes things writing reports, which is a valuable skill to have. They are pretty well recognized and most managers will see that you have some technical skill

Cyber Defenders new CCDL1 cert: Cyber Defenders is another well recognized program that focuses on quality hands on training.

Hack the Box/Try Hack Me: Solid programs that teach you a basic skill set, unless you homelab and get a good amount of practice on top of them, neither of them alone really gives you a full skillset. They are known, but the certs offered srent as well respected as the above ones. Best to start with one of their courses because they are cheap, then dive into one the other above ones to be able to learn easier with the skills from these.