>you look back and see that almost nothing you've built is still in use, or will be for very long after you're gone.

Software development has more in common with agriculture than architecture. The code always needs maintenance.