I think this is part of the issue. Most activities can be divided into two categories (obviously this is only one of many different ways to categorize):

1. Things which are done primarily to accomplish a specific goal

2. Things which are done primarily for the joy of doing them.

Many tasks have aspects of both of these things. Automation, in all it's forms, is a way of maximizing the first, often at the expense of the second. When a new category of task first falls to automation, I think it takes a while for us to figure out how to pursue it solely for the second, but the two can co-exist. Backyard gardening and industrial agriculture both have their place.

Right now, coding and tech is, seemingly, in the middle of that transition. It's going to take a while before people learn to separate the two kinds of goal I think.