That's exactly how MaxCDN and SimpleCDN work, but Cloudfront and Rackspace Cloud don't pass through requests from your own server; rather, they require you to manually upload the files you want to serve via CDN in advance.
Instead, Amazon's front end should just check the incoming accept-encoding header and automatically compress as needed.