Some other secrets (like RDS instance master passwords) can't be encrypted, but I like to use a trick where you have a local provisioner that runs after the instance gets created, which updates the just created DB and sets the password to a random value and prints it to stdout so you can save it in your secrets management tool of choice. The value saved in the terraform state is no longer valid.
Some other other secrets, like elasticache auth tokens - there's no solution, they'll always be available as plaintext in the statefile.
Overall agreed that Terraform needs to do better here.