Shrine of the Storm - Shrine features a lot of trash pulls with high mob count which will obviously spawn a lot of orbs, but the boss fights are where this affix is the most dangerous. When Aqu’sirr splits into his smaller Aqualing forms, you will need to keep an eye on three different mobs that are spaced around the room. Council and Stormsong aren’t terrible, but then you’ll have to deal with Vol’zith. Vol’zith becomes incredibly frustrating on Explosive because each of his adds can spawn Explosives, and they will be spread out across the room. If you’re trying to keep the Whispers of Power debuff for the whole fight (as you should be), any of the Explosive orbs going off might kill you, so Explosive makes this fight stressful.
Temple of Sethraliss - Another dungeon where Explosive is only an occasional issue, but it can easily wipe you on some of the bosses. Aspix and Adderis will each spawn Explosive orbs, and this can be extremely dangerous because a lot of classes have incidental cleave abilities that will chain to the boss if you target the orb. If that boss happens to be the boss with Lightning Shield, you’ll get zapped. Adderis also melees players near him while Aspix is active, so any melee trying to kill orbs near him might get whacked. Avatar is the real headache in here, though, as each add on the fight can spawn orbs, and the adds are always spread out around the room.
Motherlode - There are a lot of big pulls you’ll want to do in Motherlode, and most of them feature random damage abilities from the trash that hurt quite a bit already so any Explosive orb that goes off might kill someone. Explosive can also gum up some of the stealth skips that groups like to employ after the second and third boss.