Completely agree, Terraform doesn't abstract away the cloud specific bits, it pretty much exposes the raw resources.

Terraform is "multi provider" not "provider agnostic".