The answer is that they all suck. I've used them, and I've written them. They sucked 20 years ago, and they suck today.
But they suck differently, for different reasons, and they suck in different magnitudes in the hands of different teams, with different needs.
I have never met an org that was happy with their infrastructure tooling! But I have met some that were happier with some tools than with others.
It's horses for courses. Terraform is a contender for some use cases. Nothing more, nothing less.