This one is a whiff. Contrast to Eye of Chaos, which is basically an upgraded version of Rite of Seeking, this spell fails in nearly every way to supplant the gold standard Shriveling.
Let's compare...
Eye of Chaos vs Rite of Seeking/Sixth Sense
-Similar resource cost.
-Eye of Chaos is at default a "double success" like Rite of Seeking with 1 less charge and no downsides.
-Unless you're playing TCU no downsides for failing a check (i.e. drawing six curse tokens on an investigate only benefits the spell, often hugely).
Armageddon vs Shriveling
-Armageddon is more expensive.
-Armageddon is at default a "single success" with a weapon, dealing 2 damage base. Shriveling however, deals 3.
-Shriveling has a larger modifier for attack (+3 vs +2).
-Unlike Investigation actions, many fight checks do have penalties for failing (i.e. Retaliate). So even pulling one curse token is going to start making you nervous with even the most hearty spell casters. You'll need to pull at least 2 for the effect to even matter on game state, default putting you at -4 starting out.
-Steals curses from Eye of Chaos.
Overall, I find this spell is severely underpowered. Its almost useless on bosses because most of them have retaliate and if you power up the spell at all you're basically guaranteeing you'll get crunched, which mystics have minimal ability to survive. You could pair it with some evasion tool (i.e. sword cane) but then you're using two actions to attack, and of you don't pull at least four curse tokens you're still behind what you would have been with shrivelling.
As such, I tend to skip this spell and just run Shriveling with Eye of Chaos for curse based builds.