Have you work on a closer integration for content supplied through the Admin interface, and CDNs like Amazon CloudFront? E.g., if I upload an image in the CMS, will it replicate to a CDN automatically and use the CDN URI instead of the Magento URI?

This is currently not under active consideration, however we may explore options in this area within the next 6 months.