(aws-cloudfront-origins): Support dualstack domain name (ipv6) for S3 origin

### Describe the feature

It looks like that [aws-cloudfront-origins](https://github.com/aws/aws-cdk/tree/master/packages/%40aws-cdk/aws-cloudfront-origins) doesn't support a dualstack endpoint for S3 origin. According to [aws_s3.Bucket](https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_s3.Bucket.html), it provides `bucketDualStackDomainName` attribute for ipv6 or `transferAccelerationUrlForObject()` method for Transfer Acceleration URL. I want to configure S3 Origin enabling via both ipv4 and ipv6. But, I don't know how to configure it.

### Use Case

I guess these documents are related to enabling ipv6 with CloudFront and S3.

* https://aws.amazon.com/jp/about-aws/whats-new/2016/10/ipv6-support-for-cloudfront-waf-and-s3-transfer-acceleration/
* https://docs.aws.amazon.com/Route53/latest/DeveloperGuide/routing-to-cloudfront-distribution.html#routing-to-cloudfront-distribution-config

### Proposed Solution

_No response_

### Other Information

_No response_

### Acknowledgements

- [ ] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

2.25.0

### Environment details (OS name and version, etc.)

Ubuntu 20.04.4 LTS

Start in packages/@aws-cdk/aws-cloudfront-origins and compare its S3 origin handling with the aws_s3.Bucket bucketDualStackDomainName and transferAccelerationUrlForObject() APIs. Clarify which endpoint CloudFront should use for dual-stack access, then verify the resulting origin configuration supports both IPv4 and IPv6.

Written by the indexing model from the issue text.