In principle, for the Inferno spell, you can combine the enhanced effect of Fireball and Summon Fire Elemental, so that a pillar of fire is in the center of the explosion.
With Tornado, it's simple: take Summon Air Elemental, enhance it, and that's it – Tornado is ready.
Check out the video; the mod author shows off new spell effects. In principle, everything is clear there, and you can try to replicate something if you really want to (by the way, I got the idea for the Tornado from his mod).
https://www.moddb.com/mods/homm-5-chaos-theory/videos/divine-wrath#imagebox
Wow, that's cool, I hadn't seen it before. Summon Black Hole is just awesome.
Added 1 minute ago
Hey everyone, this week I spent time in Photoshop and Premiere after work to create this one and a half minute video. I think it turned out quite clearly. In the video, you will see what classes are in the mod and what the chances are of primary and secondary skills appearing for these classes.