feat(sftp): add `aws_transfer_connector`

[haarchri]

Description of your changes

add aws_transfer_connector

Fixes #1295

I have:

• [x] Read and followed Crossplane's contribution process.
• [x] Run make reviewable to ensure this PR is ready for review.
• [x] Added backport release-x.y labels to auto-backport this PR if necessary.

How has this code been tested

tested create, update, delete and observe exisiting + uptest run

NAME                                          SYNCED   READY   EXTERNAL-NAME         AGE
role.iam.aws.upbound.io/sftp-connector-role   True     True    sftp-connector-role   107s

NAME                                                  SYNCED   READY   EXTERNAL-NAME                                                                            AGE
secret.secretsmanager.aws.upbound.io/sftp-connector   True     True    arn:aws:secretsmanager:us-west-1:609897127049:secret:sftp-connector-op-r8l3e1l9-HB4XAI   107s

NAME                                                         SYNCED   READY   EXTERNAL-NAME                                                                                                                 AGE
secretversion.secretsmanager.aws.upbound.io/sftp-connector   True     True    arn:aws:secretsmanager:us-west-1:609897127049:secret:sftp-connector-op-r8l3e1l9-HB4XAI|terraform-20240604124216352400000002   107s

NAME                                               SYNCED   READY   EXTERNAL-NAME         AGE
connector.transfer.aws.upbound.io/sftp-connector   True     True    c-8818f1d56d224cdbb   107s

[ytsarev]

/test-examples

[haarchri]

@ytsarev can you test the following example please ? examples/transfer/v1beta1/connector.yaml

[ytsarev]

/test-examples="examples/transfer/v1beta1/connector.yaml"

[haarchri]

@ytsarev its green - the fail run is from the first comment ;)