I've been passively recommending this
since November.
I use it on two of my sites, one small image board I have w/ my Asian friends who doesn't use forums, and one small XenForo installation.
Since my XenForo installation doesn't get much traffic, I cannot comment much about it.
But, for my other site, I've noticed consistently roughly 60% bandwidth saved (~50GB/mn for my small image filled site), and generally loads faster than without.
The only thing I can think of is it may break any server monitoring tool (http ping) you currently have in place. Since you are changing your DNS to theirs, and server monitoring tool pings their server to check for outage, it may or may not detect it in the event of a real outage. Changing your monitoring tool to use IP address instead of your domain name will resolve that.
How does CloudFlare differ from conventional CDN...
Short answer: CloudFlare sits in the middle, conventional CDN sits separately.
Long answer:
If you use conventional CDN, you setup your own DNS (typically) to point certain CNAME (such as cdn.mysite.com) to the CDN provider's server, and put your things there (manually or automatically, depending on how much you integrate). It is typically a one-trick pony where it distributes your information across its network, and provides it to end-user upon request.
On the other hand, if you use CloudFlare, you change your name server to CloudFlare, tries to fetch your DNS configuration from your current provider (with your aid). After it is setup, they fetch the data from your server, and relay to the end user, while caching public content for subsequent requests. CloudFlare also, with your permission, auto minifies (strips excess spaces, new line, etc.) your javascript/css to help make things load even more quickly. Additionally, CloudFlare integrates -- to some extent, I don't know detail -- with third party behavioral monitoring sites (I know of Project HoneyPot being used, not sure about others), so they can pro-actively spit out a CAPTCHA for potential known bots/spammers. There are definitely false positives from my experience, but the amount is low enough to disregard for me, and you can turn this feature off if you do not want to use it.
You can use CloudFlare and MaxCDN at the same time... until your pre-paid bucket depletes. After that, I don't really see the reason to use both