I have observed that most of the times, when I am not motivated to work, it is becasue my sub-concious mind is unable to correctly traverse the behavior tree and find a route from 'the non intuitive task' leading to the 'sexy results' I am after. My concious thinking mind has already done that.

But your sub-conscious brain being able to link the results with the efforts is not a precondition to start working. It only facilitated the process, and does not act as a deciding factor.