Does anybody know how to modify the 2D Sprite material shader to support additive textures? Would be great for explosions and whatnot.
+1 here 
Would using the particle additive shader be fine or are you talking more about diffuse detail shader? You don’t have to use just the sprite shaders for sprites.