Using this comment thread to plug a question: Is there a way to use Cloudflare (or other DNS server providers) in order to dynamically fallback to CDN A (e.g. Cloudfront) in case CDN B (e.g. Netlify CDN) is down?
The crucial part is CNAME compatibility. Most DNS services I've had experience with can only do failover between IPs.