Some mentioned in the SE Demo Vid: Dynamic Fire & Smoke, Dynamic Volumetric Clouds, Fluid-like Wormhole FX, Physically Based Advanced Water FX.
Practically every object in the world could be driven by the Niagara Particle Systems LOL. I might challenge myself to dev a game world using only Niagara.