How to get rid of this weird cross effect after boolean OR knife project?

It’s because your faces are slightly out of line. I just tried to reproduce what you did but I didn’t get that alignment problem.

Normally, you would add more loop cuts before you add the boolean, in order to give the mesh more support to carry the hole.