FWIW I've had great experiences recently with Bunny [0] to deploy content to a very affordable, very configurable CDN. Integration is also dead simple (you deploy normally to your regular site and then just replace hostname in all URLs with the CDN hostname, it handles the rest automatically)

Different than industrial CDNs but my new go-to for small-to-mid and indie sites.

[0] https://bunny.net