In space the theoretic best performance would with a nozzle of an infinite size/length, so the real size comes from a tradeoff between performance and mass.

In atmosphere the size is heavily limited by the atmosphere itself as pressure differences between inside and outside of the nozzle would destroy the nozzle structure.

For example the planned Starship upper stage by SpaceX will have two kinds of engines and nozzles.