I've always thought he wanted Manhattan to kill him, but I never suspected Moore would have intended it that way. I guess the tears at the end were more of a way to beg Manhattan to kill him, to show that he really meant it when he said kill me.