Totally depends on the challenge of the project - and it follows a bell curve. Too easy and it’s annoying, too difficult (or takes too long) and it’s fucking aggravating. But those rare Goldilocks projects that are a challenge but shit just clicks along? Chefs kiss.
I mean that's literally what it is from a psychological perspective. Your brain doesn't reward you for the mere act of finishing a task, so it's basically impossible to find motivation for it unless it ticks at least one box in your reward center.