In addition, memory bandwidth is still at least an order of magnitude higher.
Just put a huge swap file on it.
https://wiki.archlinux.org/title/Improving_performance#zram_...
I think you significantly overestimate how much they can reduce latency for SSDs. Keep in mind, even a 80286 from 1982 had a memory latency in the 200ns range[1].
[1]: https://cacm.acm.org/magazines/2004/10/6401-latency-lags-ban... (view PDF, table 1)
You could make it work with Optane except oops that just got discontinued.
HomeAssistant running SQLite on on a small cheap MicroSD card, kill it a couple of months.
Each memory cell have a lifespan of ≈ 1000 write cycles, if I remember correctly.
Maybe such computer should use some sort of treadmill allocation.