### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

DynamoDB does not correctly namespace resources based on region and account ID. 

For instance, using the same table name across accounts and regions throws an error.

### Expected Behavior

It must be possible to create resources with same name on different regions and/or different accounts.

### How are you starting LocalStack?

With a docker-compose file

### Steps To Reproduce

#### Client commands (e.g., AWS SDK code snippet, or sequence of "awslocal" commands)

```
  $ AWS_ACCESS_KEY_ID=445500880268 AWS_DEFAULT_REGION=eu-central-1 \
    awslocal dynamodb create-table --table-name CertificateTargets-local1 \
        --key-schema AttributeName=target_uuid,KeyType=HASH \
        --attribute-definitions AttributeName=target_uuid,AttributeType=S \
        --provisioned-throughput ReadCapacityUnits=1000,WriteCapacityUnits=1000

  $ AWS_ACCESS_KEY_ID=445500880268 AWS_DEFAULT_REGION=us-east-1 \
    awslocal dynamodb create-table --table-name CertificateTargets-local1 \
        --key-schema AttributeName=target_uuid,KeyType=HASH \
        --attribute-definitions AttributeName=target_uuid,AttributeType=S \
        --provisioned-throughput ReadCapacityUnits=1000,WriteCapacityUnits=1000

    # ResourceInUseException!

  $ AWS_ACCESS_KEY_ID=000000000000 \
    awslocal dynamodb create-table --table-name CertificateTargets-local1 \
        --key-schema AttributeName=target_uuid,KeyType=HASH \
        --attribute-definitions AttributeName=target_uuid,AttributeType=S \
        --provisioned-throughput ReadCapacityUnits=1000,WriteCapacityUnits=1000

    # ResourceInUseException!
```

### Environment

```markdown
OS: Ubuntu 22.04
LocalStack: latest
```


### Anything else?

_No response_
bucket_name = s3_bucket_name(bucket_name_or_arn)
    return "arn:aws:s3:::%s" % bucket_name
def s3_bucket_name(bucket_name_or_arn: str) -> str:
    return bucket_name_or_arn.split(":::")[-1]
def _resource_arn(name: str, pattern: str, account_id: str = None, region_name: str = None) -> str:
    if ":" in name:
        return name
    account_id = account_id or get_aws_account_id()
    region_name = region_name or get_region()
    if len(pattern.split("%s")) == 3:
        return pattern % (account_id, name)
    return pattern % (region_name, account_id, name)
def get_events_target_attributes(target):
    return pick_attributes(target, EVENT_TARGET_PARAMETERS)
def get_or_create_bucket(bucket_name: str, s3_client=None):
    s3_client = s3_client or connect_to_service("s3")
    try:
        return s3_client.head_bucket(Bucket=bucket_name)
    except Exception:
        return create_s3_bucket(bucket_name, s3_client=s3_client)
def create_s3_bucket(bucket_name: str, s3_client=None):
    """Creates a bucket in the region that is associated with the current request
    context, or with the given boto3 S3 client, if specified."""
    s3_client = s3_client or connect_to_service("s3")
    region = s3_client.meta.region_name
    kwargs = {}
    if region != AWS_REGION_US_EAST_1:
        kwargs = {"CreateBucketConfiguration": {"LocationConstraint": region}}
    return s3_client.create_bucket(Bucket=bucket_name, **kwargs)
def create_sqs_queue(queue_name, env=None):