MGO isn't just an explosion mod. It is a total visual overhaul. However, its explosion module is so good that it frequently ranks on lists by default. MGO focuses on "Hollywood" style.
Widely considered the choice for realism junkies, the VUAF pack does something no other mod does: it decouples the explosion texture from the smoke texture. This allows for multi-layered fireballs. dcs explosion mod top
Not every PC runs a Reverb G2 at 90 fps. If you are on a mid-range rig but still want visual flair, Better Explosions is the option for you. Taz1004 rebuilt the particle system from scratch using a "billboard" method. MGO isn't just an explosion mod