Whether their clients tend to actually be familiar with the organisations endorsing or providing the Y certification I have no idea, but even if all it does is give them a warm fuzzy feeling, that's probably enough to make it worthwhile for the consultancy that wants their business.
I’m thinking about the AWS Big Data later, but I don’t have any practical experience in that area and I refuse to be a “paper tiger” collecting certifications with no practical experience and probably a project management certification because everyone has a PMP after their name in consultancy it seems like.
I would probably study for some type of Linux certification just to transition from the Microsoft ecosystem but whether I would spend the money to get it and keep it updated is another question.
In particular, to be an “Amazon Partner” your company has to have a certain number of certifications. It also helps to have some type of project management certification.
Your skepticism of certifications is well founded, I’ve come across many “paper tigers” who had certifications up the wazoo but couldn’t code/architect thier way out of a wet paper bag.