I promise you, the cost-benefit of the PCI Qualified Security Assessors Certification is great if your company pays. You cannot take this solo. A firm has to sponsor you. The fees are steep, but employers handle that because they need you running compliance audits.
Once certified, you lead security checks and sign off on reports for big merchants. I can assure you it opens specific audit doors that other infosec certs completely miss.
If you want to see if this audit route fits your goals, check out the details on CertBoosters. Looking at the career path helps you figure out if the certification is worth it for your future in security: https://www.certboosters.com/pci/path/qualified-security-assessors