Well, you don't actually use "yet" with simple tense. So, "The director hasn't come yet" is true. As to your question about when to use the sentences, you say "The director hasn't come yet" if you are still waiting for him (process is going on). And you say "The director didn't come" if everything has already ended (you waited for him, he didn't come).