There's a guy working on a MySQL storage engine that uses S3:
http://fallenpegasus.livejournal.com/tag/s3
It's still at a very early stage in terms of implemented features, but he seems to be moving forward rapidly.
I have no idea what kind of performance he's getting -- I'm planning to check out the MySQL source sometime next week and do a test build. Extremely cool idea. :-)