I don't have a huge amount of trust in the encoding decisions that they're going to make, how the images are going to look for other people, etc.
For instance I am making the prototype of my system and testing it locally and often I look at the origin server without the CDN. I think hard about the encoding trade-offs and user experience and I don't like a black box messing with my images. Also to get the best results from AVIF encoding I'd think it would get better results if it was working from less-compressed images as opposed to what I put up which might be aggressively compressed.
Also CF Images can work with originals from your origin .
Personally I brute force all my static images to compress to a 92 VMAF score (and I'm always smaller than any of these services with better perceived quality). But I do also work with a lot of clients that sometimes add a few hundred new images pr. day and then these solutions come into play.