To go through the list:
- Every stretching/squeezing transformation has real, non-negative eigenvalues
- Every shear transformation has $1$ as its only eigenvalue
- Every reflection has eigenvalues $1$ or $-1$ (typically both)
- Every orthogonal projection has eigenvalues $0$ or $1$ (typically both)
As you noted, rotation matrices will have non-real eigenvalues, except in the case that the rotation angle(s) is a multiple of $180^\circ$. In other words, the eigenvalues will be non-real except in the case that the transformation can be thought of as a combination of "mutually orthogonal" reflections. Similarly, orthogonal transformations (transformations that can be done by a combination of reflections and rotations) will have non-real eigenvalues except in the case that all eigenvalues can be accounted for by a set of independent reflections.
Notably, reflections, orthogonal projections, and rotations (along with the orthogonal transformations) all fall into the class of "normal" transformation. A transformation is called normal if its matrix $A$ satisfies $A^TA = AA^T$ (where $A^T$ denotes the transpose of $A$). It turns out that a normal transformation will have real eigenvalues if and only if it is symmetric (that is, $A = A^T$).
Symmetric transformations all correspond to simultaneous streches/squeezes/reflections along mutually orthogonal axes. Normal transformations generalize this in that they also allow these transformations to include rotations about these same orthogonal axes (or more generally, within the planes containing any pair of axes).