I think it's reverse causation. Motivating and meaningful activities feel like quests. Boring but necessary activities that we procrastinate on make us reach for "goal-setting" as a cure for the procrastination.

Wouldn't it be nice if we could somehow feel intrinsic motivation and meaning for the boring stuff too, so that even cleaning the toilet felt like part of a grand adventure?