Regarding Orcs - it depends on the situation. Berserkers are usually cast at the beginning, and here, Frighten will be very useful, as the side and rear paths are blocked, and they will most likely run towards the enemies. Also, it depends on the obstacles on the battlefield. We scare the subordinate stack and reduce their Intuition.
P.S. Regarding Necropolis, correct me if I'm wrong.