TST: Refactor S3 tests #24039

Job	Run time
Linux-Musl	15m 26s
Linux-32-bit	18m 28s
python-dev	0s
macos-13 actions-310.yaml	36m 56s
macos-13 actions-313.yaml	36m 52s
windows-latest actions-310.yaml	43m 41s
macos-14 actions-310.yaml	27m 3s
macos-13 actions-312.yaml	31m 21s
macos-14 actions-313.yaml	23m 37s
macos-13 actions-311.yaml	32m 59s
windows-latest actions-313.yaml	42m 14s
macos-14 actions-311.yaml	24m 18s
macos-14 actions-312.yaml	21m 21s
windows-latest actions-311.yaml	39m 50s
windows-latest actions-312.yaml	39m 22s
Pyodide build	23m 38s
Freethreading	21m 36s
Future infer strings	44m 47s
ubuntu-24.04 actions-312.yaml	44m 49s
Locale: it_IT	23m 27s
Pyarrow Nightly	20m 12s
ubuntu-24.04-arm actions-310.yaml	36m 54s
Pypy	1m 17s
ubuntu-24.04-arm actions-312.yaml	36m 33s
ubuntu-24.04 actions-313.yaml	46m 51s
Minimum Versions	23m 3s
ubuntu-24.04-arm actions-311.yaml	35m 31s
ubuntu-24.04 actions-310.yaml	46m 10s
Downstream Compat	5m 9s
Future infer strings (without pyarrow)	38m 30s
Locale: zh_CN	24m 24s
Numpy Dev	16m 26s
ubuntu-24.04 actions-311.yaml	42m 48s
ubuntu-24.04-arm actions-313.yaml	34m 36s
	16h 40m 9s

Provide feedback