One situation in which it is essential to use groupoids is the study of orbifolds.
Slogan: The set of points of an orbifold is a groupoid.
Here's a concrete problem that is illuminated by the language of groupoids. Suppose I have an orbifold $M$ with a singuar stratum $X$. The stratum $X$ is isomorphic to $S^1$, and its isotropy group is some finite group $G$. Let's also assume that $X$ is oriented.
Question: What is the "monodromy" of going around that stratum?
At first glance, one might guess that it's an element of $Aut(G)$.
That's wrong! The monodromy is an element of $Out(G)$.
So we have a somewhat paradoxical situation in front of us: there is a group associated to every point of $X$. Yet, the monodromy is not acting by automorphisms of that group.
Here's an example of orbifold that nicely illustrates the kind if situation that can occur: $$ M = (S^1\times V )/S_n, $$ where $S_n$ is the symmetric group and $V$ is a faithful representation. The group $S_n$ acts on the circle $S^1$ via the projection $S_n\twoheadrightarrow\mathbb Z_2$, and then the antipodal map. The representation $V$ of $S_n$ is just put there so that the orbifold isn't too degenerate (it can be omitted if you don't mind working with non-effective orbifolds).
In that example, the manifold $X$ is $S^1/\mathbb Z_2$. The monodromy is computed in the following way. Go half way around $S^1$, and then identifying "$S_n$ at point -1" with "$S_n$ at point +1" via any group element that sends -1 to +1. A choice of such an element yields an automorphism of $S_n$. But since there is no best way making such a choice, the only canonical thing is its class in $Out(S_n)$.
Ok. Maybe now is good moment to try to remove some of the confusion.
It all becomes more clear once you realize that the thing that is associated to a point of $X$ is not a group. It's a groupoid:
If $[M/G]$ is an orbifold and $x$ is a point in $M/G$, then the groupoid that lives above $x$ has objects given by points $m\in M$ mapping to $x$. An arrow from $m$ to $m'$ is given by a element of $G$ that sends $m$ to $m'$.
The monodromy is then simply an automorphism of that groupoid (so now there's nothing weird any more). But this automorphism might fail to fix any of the objects of the groupoid. And so it can't be viewed as an automorphism of the corresponding group, unless you make some unnatural choices.