I think spells requiring cabals of mages to invoke are a bad fit, as @Oofta points out. BUT, whatever it should be should require powerful mages (or equivalent) to build are on brand. Only really rich nations can make nukes, after all, but they can be stockpiled, stolen, wielded by rogue elements, granted to allies and so on. Maybe something that opens a rift to Hell (or the far realm, or whatever) but can be targeted through clairvoyance. So a terrorist would have to be willing to die to use it to make their statement, but a powerful nation can drop it like a bomb from a safe distance by way of crystal ball.