dependency on unsupported AWS SDK v2

### How did you install the Amplify CLI?

yarn

### If applicable, what version of Node.js are you using?

20

### Amplify CLI Version

14.0.0

### What operating system are you using?

Mac

### Did you make any manual changes to the cloud resources managed by Amplify? Please describe the changes made.

No manual changes made

### Describe the bug

Various `amplify-cli` packages have a dependency on AWS SDK v2. This is end-of-life and will be unsupported on September 8th 2025.

https://aws.amazon.com/blogs/developer/announcing-end-of-support-for-aws-sdk-for-javascript-v2/

The packages are:
```
packages/amplify-appsync-simulator/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-auth/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-function/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-geo/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-hosting/package.json: "aws-sdk": "^2.1692.0",
packages/amplify-category-notifications/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-predictions/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-category-storage/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-cli/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-console-hosting/package.json: "aws-sdk": "^2.1692.0",
packages/amplify-console-integration-tests/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-dynamodb-simulator/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-e2e-core/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-e2e-tests/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-environment-parameters/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-opensearch-simulator/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-provider-awscloudformation/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-storage-simulator/package.json: "aws-sdk": "^2.1464.0"
packages/amplify-util-import/package.json: "aws-sdk": "^2.1464.0"
packages/amplify-util-mock/package.json: "aws-sdk": "^2.1464.0",
packages/amplify-util-uibuilder/package.json: "aws-sdk": "^2.1464.0",
```

### Expected behavior

The packages should be updated to use packages from AWS SDK v3, i.e. packages like `@aws-sdk/client-*`

### Reproduction steps

1. Checkout code
2. Search for aws-sdk in package.json files

### Project Identifier

_No response_

### Log output

```
# Put your logs below this line

```

### Additional information

_No response_

### Before submitting, please confirm:

- [x] I have done my best to include a minimal, self-contained set of instructions for consistently reproducing the issue.
- [x] I have removed any sensitive information from my code snippets and submission.

Start by auditing the AWS SDK dependencies in the listed package.json files, then trace each package's existing aws-sdk usage before mapping it to the appropriate AWS SDK v3 package. Verify that all listed packages no longer depend on aws-sdk v2 and run the repository's relevant CLI, simulator, and integration tests to confirm existing behavior.

Written by the indexing model from the issue text.