As someone using Terraform from it's first release on I still think that Terraform has one fundamental flaw:

It always looks at things using provider specific resource, while IMHO it should just expose a bunch of predefined resource types (see rOCCI specs e.g.) and then allow you to attach a specific provider to it.

IMHO the biggest win as a user would be having not to have an implementation for every provider over and over. Do we really need to have a consul module for Azure, AWS, Tudeluuu and god knows who? No.

That being said, Terraform in the long run still is the most reliable tool in that space.

The whole situation about state management is... lacking. Experience says the one thing no client ever wants in the cloud but always on prem is state.