For sprites I use "EXGEN", a very complex solution.
You can buy it on "thegamecreators.com".

If you have money - the best way is the "reel explosions" from artbeats.

The old school way is to script some nice particle effects with wdl.