As a programmer I already find most of my job consists of making better tools to do my "actual" job with. Directly implementing business functionality is <20% of my time. I'm much more productive than I was 5 or 10 years ago - but my job gets more interesting, not less, as I move up the parts I do "by hand" to a higher and higher level.