The way he acted only indicated that his programmer/creator had ulterior motives. It was obvious that his main function was not what he had Shaw and company believe it was, which is why he was being such a sneaky in the Alien complex/ship. It became apparent that it was actually to do whatever he could to prolong Weyland's life. My initial thought about poisoning Charlie was just because he was experimenting what effect it had, it's not like he could have know what it did. The "children just want to see their parents die" line was possibly explaining to the audience why the Engineers wanted us dead. They obviously came and visited earth throughout its history and decided that they needed to destroy us, presumably before we destroyed them (children wanting to see their parents die). I'm not sure that he obviously had emotions, as much as he was obviously programmed to hide his main objective, IMO.