Brand of Cthugha is good fight spell for mystics, and great alternative of Shrivelling. In my opinion, it's fine to get BoC only if your role is flexible, or BoC + Shrivelling if your role is fighter.
Then, what's difference between Shrivelling and Brand of Cthugha?
- Net-damage is similar in most case: Shrivelling(5) has 12 net-damage as maximum, and BoC(4) has 9 net-damage. However, you can control charge for BoC; if you attack 2-health enemies or 4-health enemies, BoC is better. In most case, net-damage is almost same except boss raid case.
- Backfire effect is controllable: BoC has terrible backfire effect, which make you lose 2 action which cannot be prevented by Deny Existence. However, you can control backfire unlike Shrivelling. For standard difficulty, chaos bag contains lots of -1 and -2, and single -3, -4, or -5. To avoid backfire effect, you just boost your skill value as "failure only if " or 4 more which only 1 token generates backfire. If you perform attack as last action, you don't need to consider backfire since you have no action to lose.
- Failure penalty is really small: When you fail a skill test, you have no backfire effect of spell and no charge is spent. Moreover, it's burdenless to attack the enemy engaged with another investigator unlike Shrivelling because they take only 1 damage(or zero? it's arguable) even if you fail the attack test.
- No synergy with charge-based card, so durability is not good: Since BoC(4) spend lots of charges, it's bad to use charge-based combo such as Book of Shadows, Recharge, Twila Katherine Price, or True Magick. Additionally, it's not good to choose BoC as the target of Knowledge is Power, since you should spend charge even if you play KiP. Thus, if you want to use BoC continual, you should find another method like Spirit-Speaker, Prescient or cycling your deck.