It plays when you're facing the Three Mage-Sisters at Heroes in Another Dimension, and when facing Morpho Knight EX as the Three Mage-Sisters. However, it also seems to work well in scenarios where the final boss is at critical health, or when Kirby is using a Super Ability (such as Ultra Sword).
I've been going through and finding songs I like from all the games I own, usually just 1 per title but I've been unable to narrow down the choices from Diddy Kong Racing, Paper Mario TTYD and the Kiseki series. I came across One Piece Pirate Warriors and I remembered this gem and its remix.
The games I mentioned before I already knew I wouldn't be able to choose from but I didn't think OP Pirate Warriors would be in that list too lol.