Migrate acceptance tests to new testing framework

[taiidani]

What Is Changing

Migrating acceptance tests from the SDKv2 implementations to the new Testing framework, via https://developer.hashicorp.com/terraform/plugin/testing/migrating.

Test Steps

• [x] Have you updated the docs/ folder to match your change?
• [x] Have you exercised your change using the examples/ docker compose setup?

make testacc