IME this "second-guessing" is more often right than wrong. You can always return to a project that motivates you, but you can't get back time spent digging a hole deeper, and often it leads to tunnel vision and bad habit formation.
Not every "project" needs to become "finished" or "product".