(e2e tests) add e2e test for terraform deployment

[cogwirrel]

Description

Add the terraform equivalent of the cdk-deploy test to our CI workflow.

Motivation

Better tests for generated terraform infrastructure with continued deployment.

Suggested Implementation

• Generate a "kitchen sink" type project with IAC as terraform (refactor the existing terraform smoke test)
• Vend a main.tf which instantiates all the relevant modules and wires them up, as well as outputting the relevant urls/arns
• Write a terraform-deploy test which generates this project and deploys, invokes everything in the same way as cdk-deploy, and finally tears everything down
• Add the terraform-deploy test to the ci.yml github workflow

Contribute to feature

• I'd be willing to implement this feature