Writing to S3 with a wrong region does not have good fallbacks

[jaychia]

Describe the bug

When writing to AWS S3 with no region specified, PyArrow doesn't seem to be handling the redirects correctly.

To Reproduce

No response

Expected behavior

No response

Component(s)

Parquet

Additional context

No response