I found this question and its subsequent answer extremely helpful in its example of the use of the $\epsilon-\delta$ definition to demonstrate the value of a limit. I also notice that the example itself seems to me to be quite easy to demonstrate without recourse to the $\epsilon-\delta$ definition.
Having said that, is there value in this definition beyond mathematical rigour? Are there limit problems (in single variable calculus) that require the $\epsilon-\delta$ definition in order to either find a limit, demonstrate that one exists, or to prove a result?
Consider the function $f: \Bbb R \to \Bbb R$ defined by $f(x) = \dfrac{1}{q}$, if $x = \dfrac{p}{q} \in \Bbb Q$ with $\gcd(p,q) = 1$, and $f(x) = 0$, for all $x \not\in \Bbb Q$.
It is hard to imagine how one would prove $\lim\limits_{x \to 0} f(x) = 0$ without recourse to the epsilon-delta definition.
That said, using the definition is cumbersome. Building up a repertoire of continuous functions makes things much easier, because we can evaluate limits by simple substitution, in many cases. In a sense, this "shifts the difficulty" into establishing our functions are continuous, but many commonly used functions can be "broken up" into simpler components via sums, multiplying by a constant, multiplying functions together, or through composition, enabling us to prove continuity for a few simple cases, and continuing from there.
Indeterminate forms like $\dfrac{0}{0}$, or $\dfrac{\infty}{\infty}$, are a "special case" and need to be handled with caution.