Should an engagement ring have a diamond?

I’m just curious. I know that engagement rings can be other types of stones, and don’t have to be an actual diamond. But, if he were to propose with a cubic zirconia, is that ok? Would you say yes. Or, would you rather him wait until he can afford a more real stone/diamond?