Motivation certainly doesn't work like that in my brain. Consistency in pursuing goals I know on paper are the right choice despite lack of motivation is the only way I've achieved anything.
If you can wed career goals with dopamine, that's wonderful! But I suspect you're extremely lucky.