That cool unstable vortex effect in the Stargate movie and TV shows was created using a cool practical effect as a baseline, and then adding some CG touches.