You still aren't explaining what you use cloudflare for or why you included them in your architecture.
I guess my secondary question is, why do many people running pretty small websites use and swear by them? I’m just trying to understand how necessary CDNs are, and is CF the CDN to use?
Most of which are just small personal sites
I use Cloudflare to: 1. Give me easy SSL on all of the sites ("flexible", so not 'proper' ssl) 2. Hide my origin IPs 3. Easy compression, minification, caching, etc. 4. Host some sites on Cloudflare Pages
CDNs certainly aren't necessary for small websites but I'd say Cloudflare is the one to use if you want one, but also want to avoid spending money.
If you feel like you don't need or want one, honestly just don't bother with it.