The special cases of the $O(2)$ model and $O(3)$ model are particularly well-studied. Higher values of $N$ do come up occasionally, see for instance the $O(4)$ model. The Ising model is the case $N=1$, and the case $N=0$ is covered by self-avoiding walks.
This also goes by the name of the “n-vector model”, or “non-linear $\sigma$ model$.