I’ve had better experiences with rclone mount vs s3fs, but the experience isn’t great. It’s not a posix filesystem so stuff like file locking won’t work. Which makes it dangerous to run databases (incl SQLite) on top of.
Rclone has options to enable a local cache as well. It helps with performance, but I haven’t tested the performance too much yet.