Stardust by itself doesn't seem to do anything. But it lets you get moons and planets, which gives you stardust and energy, which lets you get galactic points, and those DO have mechanical effects.
on the other hand after a while you have infinite amount of stardust so all those extensions are free of charge. :D