(edit:) Huh... a few months ago Amazon dropped their bandwidth prices by 20%. These new prices are now more in line with "expensive CDN" as opposed to "more expensive than expensive CDNs". Still much more than I'm paying.
That said, I have never been quoted a "per-request" charge by a CDN, so I'm not certain how much more expensive that extra charge ends up making this service (although, of course, for large content that will amortize pretty quickly).
(Finally, Cloudfront has many fewer abilities than the "real CDNs" I've used, fewer POPs, and the story on "how long does my stuff stay in cache" is unclear. They certainly aren't on my radar yet, although they are slowly getting better.)
It sounds like you haven't really looked at CloudFront.
http://aws.amazon.com/cloudfront/faqs/#How_long_will_Amazon_...
Their support for .Net isn't very good, so it took me a while to get things working for their REST services. Overall a much better product with much better support.