An important point is that a "pole" is actually the same thing as a removable singularity, if we think of our function as a map that takes values on the Riemann sphere (which is the complex plane with a point at $\infty$ added; the complex structure near $\infty$ comes from the map $z\mapsto 1/z$).
So a function that has a removable singularity or a pole at $z_0$ doesn't have a "real" singularity there at all; rather, we can extend the function to an analytic or meromorphic function in $z_0$. If we cannot extend the function in this way, the singularity is indeed "essential"; i.e., we cannot get rid of it. Thus the terminology is not one that is merely used for convenience or pedagogical purposes; rather, it is extremely natural.
As has already been mentioned, the magic of complex numbers results in many beautiful facts about essential singularities: functions with these singularities are very far from extending continuously.
The simplest of these facts is the Casorati-Weierstraß Theorem: The image of a neighborhood of an essential singularity is dense in the complex plane.
This is just a consequence of the removable singularities theorem. (If $f$ omitted a neighborhood of $a$, we could postcompose $f$ with a Möbius transformation that takes $a$ to infinity and see that the resulting function has a removable singularity.)
The most well-known result of this type is Picard's theorem which was already mentioned.
There are various beautiful strengthenings of Picard's theorem that arise from Nevanlinna theory, and Ahlfors's theory of covering surfaces.
So all essential singularities have some things in common, but on the other hand this should not lead us to believe that they are all the same. What they have in common is complicated behaviour, but they can be complicated in very different ways! Indeed, different transcendental entire functions (those that have an essential singularity at infinity; i.e. are not polynomials) can vary very much with respect to their behavior near infinity. Just for example, for some such functions, such as $z\mapsto e^z$, there exist curves tending to infinity on which the function is bounded, while for others this is not the case.
As $z \to n \pi$, $\sin(z) \to 0$, while $z^2 \to (n \pi)^2$. If $n \ne 0$, this implies $|f(z)| \to \infty$, which says you have a pole. For $n = 0$, the limit is an "indeterminate form". Now use the fact that $\sin(z)/z \to 1$ as $z \to 0$.
Best Answer
Starting from an isolated singularity $c$ of any type of a holomorphic function $f$, you can reach the first situation by just declaring $f$ not defined in the points $c_n$ of a sequence converging to $c$.
So a limit point of removable singularities can be any kind of isolated singularity after removing the singularities in the $c_n$.
If $c$ is a limit point of poles or essential singularities, every punctured neighbourhood $U$ of $c$ is a neighbbourhood of some (almost all, actually) of the poles or essential singularities, hence $f$ is unbounded on $U \setminus \{c_n\}$.