Yeah. I would keep the db local, and probably the thumbs and intermediary photos too. But the full resolution would probably be in S3.
dB's are not good on object store, and not good running over the internet. I wish they had native S3 storage, as that would allow for high speed access, where as this will download to the server, then upload to the client which will add latency.