Origin failover support for the CloudFront distribution

### Is this feature request related to a new or existing Amplify category?

hosting

### Is this related to another service?

CloudFront, S3

### Describe the feature you'd like to request

Hosting should support origin failover for the CloudFront distribution. This is to maintain high availability and not be impacted by S3 outages in one region.

### Describe the solution you'd like

Ability to configure a secondary S3 bucket in a different region that the main bucket CF serves the static content from.

### Describe alternatives you've considered

https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/high_availability_origin_failover.html

### Additional context

_No response_

### Is this something that you'd be interested in working on?

- [ ] 👋 I may be able to implement this feature request

### Would this feature include a breaking change?

- [ ] ⚠️ This feature might incur a breaking change

The issue names no files, tests, or entry points. Start by locating the hosting category's CloudFront and S3 distribution configuration, then read the linked AWS origin-failover documentation. Done means hosting can configure a secondary S3 bucket in another region and CloudFront can fail over to it during an origin outage.

Written by the indexing model from the issue text.