BunnyCDN, the one I am using, does offer DDoS protection[1]. I would say that there's some inherent risk in that happening when you're using a CDN or hosting for that matter. None of the CDNs I know offer a spending limit. But as a small business, I am willing to understand the situation and waive off the charges on case-to-case basis.
On the other hand, if you incurred that kind of egress on Cloudfront, you'd have no option but to pay. The bigger platforms rarely budge in these kind of situations.
I would also add that large-scale DDoS attacks (something like 80+TB!!) are unusual, especially when the target is just a small website.