Think of it like this: a unitary matrix is to a complex vector space as an orthogonal matrix is to a real vector space (and, if you ever come across it, as a symplectic matrix is to a quaternionic vector space). Most of your intuition for ordinary rotations can be applied to unitary matrices acting on complex vectors. For example, it's always possible to apply a unitary transformation to a vector to get it in the form (a,0,0,...,0), for some real a>0. To see why, first try to see why the corresponding thing is true for rotations of real vectors, and see if you can adapt the argument to the complex case.
Incidentally, a matrix that is both unitary and real is just an orthogonal matrix. Since it's real, it doesn't mix up the real and imaginary parts of a vector, so if you write the vector as \vec u + i \vec v, then a real unitary matrix R takes this to (R\vec u) + i( R \vec v), where \vec u and \vec v are ordinary real vectors and R is an ordinary rotation. But these aren't the most general unitary transformations, there are others whose matrix elements aren't all real. For example, the best you could do with a real unitary matrix is rotate your vector into the form (a,b,0,0,...,0) (can you see why this is true? - think about rotating u and v simultaneously with R), so clearly the complex unitary matrices are important.