Particle Illusions, or PI, is an excellent piece of software for FX generation!

Here is a low cost alternative to PI: Timeline FX

One great advantage of Timeline FX over PI is that it can generate seamlessly looping FX'es, which I don't believe PI can.