Self-assembly of frustrated and disordered systems -- equilibrium microphases and out-of-equilibrium active matter