I think a lot of us aren’t rational about it. I tend to feel excited about changes for which productivity is a side effect, even if it’s not my motivation. It’s hard to say no to extending my capabilities and insulating myself from the more boring repetitive tasks.
If your job was 80-90% shoveling and one day you were offered use of an excavator, wouldn’t you find that exciting even while realizing the shoveling part of your career is probably dead?