If you stick a BSB with the Totem of Prophecy into a unit of cav. or kroxigors do they cause terror? Taking the wording certain spells into consideration which make units cause fear unless they already cause fear in which case they case terror, I would think that it might.
Nope, the totem of phropacy does not make units that cause fear cause terror, unfortunalty it is useless in those situation. Though hopefully in the new book they will change it.