I work with them daily, and have done so for 4 years now. It still sucks.
Unfortunately it's (Terraform, not TFE/TFC) the best in its class, and quite frankly I'm not smart to solve its issues.
We're striving to build a product that's both highly customizable and has a good UX, improving on many of the pain points. The migration path is straightforward and it'd be great to hear what you think about it!
[0]: https://spacelift.io
Disclaimer: Software Engineer at Spacelift
Plenty of people probably never run into those problems. But if you do, it's pretty terrible.
To be fair, there isn't really anything better. Pulumi and CDK address some of the limitations by using a "real" programming language, but introduce different issues. And bugs in providers are probably unavoidable, and are partly the fault of poor APIs from cloud providers.
Most of these problems I encounter aren't even down to hashi themselves. The GCP provider consumes from google's magic modules repo, which is often out of sync with the GCP API. Or in plenty of cases, it is in sync, but the API does not expose features in the same way as the console.