Programmers would disagree with your sentiment. And they will be the ones with the most job opportunities, along with engineers, and others in applied sciences in the near future.
Meanwhile tangible goods will be created by robots, robots that are made by engineers and programmers.
What you're talking about -- finding work that is personally satisfying, is something people would and should do as a hobby, or once something like UBI is in place. It's not entirely fantasy. There are less and less jobs due to automation. We will have to solve this problem eventually. I guess the alternative is total economic collapse.