I’ve been lucky to meet people throughout my life who were motivated by that, not by money. Some where in creative professions, some not, some had big salaries, some not.
I guess automation and UBI could solve that replacing the proverbial janitors with robots. But then it may just incentivize more people to lay in bed and stare at the ceiling all day. Is it a bad thing? Is it a good thing? I do tend to believe most people will eventually fall into doing some kind of rewarding work-like activity if left to themselves completely and money was taken out of the equation. On the other hand relationships/ families may be a time-suck and many peopl etc would just “spend time with the kids” all days.