enable lookupXXX functions for cross account

### Describe the feature

It would be great to be able to lookup resources in another account.

### Use Case

For some x-acc access you might want to reference a resource in another AWS account and still use lookup to get the reference.

Examples could be SQS, SNS, Buckets, or HostedZones

### Proposed Solution

`fromLookup` takes optional parameters that specify the AWS environment to do the lookup in. Prereq would be the target account trusting lookups of the stack account.

### Other Information

_No response_

### Acknowledgements

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

### CDK version used

v2

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

All

The issue names the fromLookup APIs and examples including SQS, SNS, buckets, and hosted zones, but no files or tests. Start by locating those lookup implementations and their existing environment handling; done means supported lookupXXX functions can query a trusted target account without breaking current same-account behavior.

Written by the indexing model from the issue text.