For the Stellaris Nemesis DLC we added a new endgame megastructure, that when you finish constructing it wins the game.
It have 3 upgrade stages you need to go through, and with every upgrade the effect grows bigger and more chaotic.
It was a very big effect, and I ended up doing all the effects and concepts for it.