I concur, there is no "fire and forget" solution comparable to what a physical medium gives you. And I could have probably avoided the CD-RW corruption by dumping the whole image on a new CD / DVD / USB storage every now and then.
I also have some external magnetic HDD that is now already ~10 years old, stored in the same conditions as the aforementioned CD, let see how it fares in 2032 :)