[Python] Expose new S3 option `check_directory_existence_before_creation`

[pitrou]

Describe the enhancement requested

Followup to the parent C++ PR.

Component(s)

Python

[jorisvandenbossche]

Issue resolved by pull request 41972
#41972