I ended up with an home server with 40GB of RAM (thankfully bought a couple years ago) and I take advantage of it when I build Rust applications but for a very long time my home lab was a 1st generation Raspberry Pi.

512MB of RAM are definitely sufficient for many workloads, you need to be picky on what you run and choose software written somewhat efficiently.