To some degree, both categories can also co-exist in the same person.

Some people are self-motivated when crunching numbers on spreadsheets because they find it satisfying but would need to be dragged kicking and screaming to provide phone support -- and vice-versa.

And there are probably some jobs that it's more common to be self-motivated for than others. Garbage collection? Data entry?