There are several parts to a URI (check out RFC 3986 for more detail). DNS is only concerned with the Host portion, s3.site.com, so you cannot have part of the path in the DNS entry.
You need to use Virtual Hosting-Style URIs with Custom CNAME to achieve what you are trying to do.