If you’re looking to add atmospheric effects such as lightning to your scenes it can be much too easy to think in 3D and try to add splines with animated paths, set up emitting materials and so on.

Adobe After Effects is pretty much the default software for motion graphics, but you can't overlook the fact that it's expensive and resource-hungry, and it's also not always the most intuitive tool.