Does Calibre support S3 these days as a storage backend?

No but you can use s3fs

(I have my Calibre library in iCloud Drive, but if I wasn't inside the Apple Ecosystem I'd use R2)