Interesting read. Even though you had only medium amount of trouble, it was enough to once again convince me my earlier decision to not do this is the right one. My Hetzner instance had an extended outage for the first time in its livetime this year, and after that I considered moving to CDN. However, due to the little things you list here and your bottom line of " For a blog my size it’s most likely overkill", I decided to just run a Hetzner instance without CDN.
Reading https://solar.lowtechmagazine.com/about/ made me reconsider if 24/7 uptime with 99.9999% SLA is really that important. It's a poster on the internet. What does it matter if the poster occasionally falls off?