I'm not sure about the CDNs themselves, but there are many dozens of commercial video hosting services on the web.
You can upload your video to cloudflare stream, get the embed code and put in on your own webpage. No programming needed unless you want to access it via api for some custom integration.
cloudflare has "stream" product which offer both livestreaming and on demand video options.
It's still very raw, though. They're effectively giving you the edge storage, playlist streaming, etc. but you still need to setup the player and website surrounding it. Most indie creators would still (rightly) struggle with setting that up effectively.
I think the targeted market is just different. I don't expect cloudflare to ever offer some kind of self-hosted paywalled pages or something similar like vimeo.