To get the wisdom of the Ancient, one needs an extreme concentration of psionic power. Executor able to do that will receive unbelievable technologies, perfected over millennia.
He has a positive effect on Destruction of the units: Matriarch and Patriarch.
Ability to build Arbiter and other unexplored benefits.
+1 planet for colonization per level.