Are/were there any non-psychopathic or sociopathic serial killers?

Theoretically, yes. A person who is legally insane and takes the lives of others because he's convinced that he's justified in doing so, such as a person who thinks that he's killing dangerous space aliens while he's killing people. However, this sort of thing is very, very unusual.