RAMFS is a genius idea. That solves most of the SD card health and speed issues without needing to get a whole hard drive. I know Puppy[0] and MX Linux[1] were made to run like that too.
[0] https://puppylinux-woof-ce.github.io/ [1] https://mxlinux.org/