> If my origin is overloaded, down, or throwing intermittent errors, I want the CDN to cover for this.

Sure, that is another configuration available by many CDNs as well.

Many CDNs however suggest that your origin is contacted by nobody except the CDN itself (not true for CloudFlare, though). It can then perfectly replicate your origin's content as it is updated without overbearing your origin.