It's one thing to start with a power series and then derive a formula for it. There are various tricks for doing that in the generating function literature, and I assume you've seen this in the derivation you mentioned for the Catalan numbers' generating function. But I'm guessing what you're really wondering about is the other way around: beginning with a function (say defined by an algebraic formula), how and why do we get a corresponding Taylor series? You can find the answer to this in a rigorous calculus or introductory analysis class, but I will give a breezy explanation here.
Derivatives measure instantaneous rate of change, which is why they are approximately equal to rates of change over small intervals. Specifically, we have
$$f'(x)\approx \frac{f(x+h)-f(x)}{h} ~~\implies~~ f(x+h)\approx f(x)+f'(x)h $$
for small values of $h$. Consider $x$ to be fixed. The above allows us to approximate $f(x+h)$ by a linear function of $h$. Linear functions are one of the simplest functions there are. We can view them as sitting at the bottom of a hierarchy of more and more complicated functions - namely polynomials, with complexity measured by degree. So to get a better approximation than linear or "1st order" one, the next step would be to get a "quadratic" or "2nd order" approximation.
Write $f(x+h)\approx f(x)+f'(x)h+\square h^2$. We may solve via L'Hôpital's rule:
$$\square=\lim_{h\to0}\frac{f(x+h)-f(x)-f'(x)h}{h^2}=\lim_{h\to0}\frac{f'(x+h)-f'(x)}{2h}=\frac{1}{2}f''(x). $$
See the "geometric interpretation" or "special case proof" sections on Wikipedia to understand why L'Hôpital's is intuitively true. Anyway, we conclude our second-order approximation is
$$f(x+h)\approx f(x)+f'(x)h+\frac{1}{2}f''(x)h^2.$$
If we proceed this way indefinitely, we can get polynomial approximations of arbitrary order, eventually resulting in the power series
$$\begin{array}{ll} f(x+h) & \stackrel{?}{=} f(x)+f'(x)h+\frac{1}{2}f''(x)h^2+\frac{1}{6}f'''(x)h^3+\cdots \\ & \displaystyle =\sum_{n=0}^\infty \frac{f^{(n)}(x)}{n!}h^n. \end{array} $$
For "nice" functions $f$, this is a true equality for sufficiently small $h$.
So what's the use of functions' having Taylor series? Well, we can approximate functions for one thing. How do you think computers can calculate things like $\sin(0.2)$ or $e^5$? Alongside other techniques, they employ power series expansions. We can also compare complicated functions' growth rates to each other in asymptotic analysis. Taylor series are also used to solve differential equations, called the Frobenius method. In any case, we know what to do with polynomials - we do algebra with them! - and in math we try to reduce new things to old things as much as possible.
What about actually calculating the Taylor series of a function defined by some algebraic formula? A lot of the time, calculating the general $n$th derivative of $f$ at a point is impractical. This is why it's often helpful to use certain manipulations to do so instead, and rely on memorizing the Taylor expansions of a certain set of "archetypical" functions like $\cos(x),\sin(x),\exp(x)$, etc. For instance, to find the Taylor series of $\frac{\sin(x) e^x}{1+x^2}$, one might multiply the Taylor series for $\sin(x)$, $e^x$ and $\frac{1}{1+x^2}$, and one would find the Taylor series of $\frac{1}{1+x^2}$ by plugging $-x^2$ in for $u$ into the geometric series $\frac{1}{1-u}=1+u+u^2+\cdots$ (itself a special case of a Taylor series).
In combinatorics, counting numbers are sometimes collected together as coefficients of some power series called a generating function. Fundamentally, they are abstract algebraic objects and treated "formally," so for instance $\sum_{n=0}^\infty n!x^n$ and $\sum_{n=0}^\infty n!^2x^n$ would be different bona fide formal power series even though they both induce the very trivial function with domain and range $\{0\}$. But sometimes, if the coefficients do not grow too quickly, the power series defines a function - indeed, it is the Taylor series of a function around $0$. In these situations there is a question of if the power series defines a function that can be described by a simple formula.
This is backwards from finding Taylor series expansions of functions defined by algebraic formulas - now we're trying to find algebraic formulas for functions defined by power series expansions. One can do this again by playing around the the series (rearranging terms, splitting them up into pieces, factoring things, etc.) and trying to identify archetypical functions' series expansions in the noise.
A more sophisticated tact is to set $f(x)$ equal to the series, then apply $\frac{d}{dx}$ to the taylor series expansion, which can be done term-by-term and thus only uses the power rule for derivatives, until we can determine that $f(x),f'(x),f''(x),\cdots$ satisfy some algebraic relation based off of their coefficients, possibly with other functions $g(x)$. This gives us a differential equation that $f(x)$ is a solution to, and so we can use techniques from differential equations to solve if we're lucky.
More about Taylor series can be read about in books or good lecture notes which cover calculus rigorously or introductory analysis, and more about generating functions can be read about in e.g. "generatingfunctionology" (freely available online) or other good combinatorics books I guess.