It seems like investing money with no risk or work involved can't beat inflation in the long run, and therefore you'd need to keep spending money over time.

No, capital really does produce value. Or, at least, it enables others to try to make money while you collect rent.