Won't the net effect of a catalyst be zero if it creates a new path with lower activation energy?
Your realisation is correct and something chemistry teachers try to hammer into their students’ heads time and time again (and yet, the point is still often lost):

Catalysts will never change the thermodynamics of a reaction. They only ease the path of the reaction. Forward and backward reactions will be accelerated equivalently.

So what is the benefit of a catalyst? There are multiple ones.

Speed

Take for example the Haber-Bosch process to synthesise ammonia from nitrogen and hydrogen.

$$\ce{N2 + 3 H2 &lt;=&gt; 2 NH3}\tag{1}$$
$$\Delta_\mathrm{r} H^0_\mathrm{298~K} = -45.8~\mathrm{\frac{kJ}{mol}}$$

This reaction is exothermic and thus should, theoretically or thermodynamicly, proceed spontaneously, e.g. if you mixed nitrogen and hydrogen in the appropriate ratio and added a spark. It does not, however. Significant activation energy is required to cleave the $\ce{N#N}$ triple bond.

Typical methods to add activation energy include heating. In the Haber-Bosch process, the mixture is heated to $400$ to $500~\mathrm{^\circ C}$ to supply the required activation energy. However, since the reaction is exothermic, heating will favour the reactant side. Increasing the pressure improves the entropic term of the Gibbs free energy equation, hence why pressures of $15$ to $25~\mathrm{MPa}$ are used.

Catalysts, based on iron with different promotors, are used to accelerate the reaction. By using catalysts, one can lower the temperature required in a trade-off between speed of reaction and favouring the product side of the equilibrium. With the conditions and catalysts used, one achieves a yield of $\approx 15~\%$ of ammonia within a reasonable timeframe. Not employing a catalyst would give much lower yields at much longer timeframes — economically much less feasible.

Direct reaction path not accessable

This is mainly true for many transition-metal catalysed carbon-carbon bond formation reactions, but is also true for some inorganic processes like the disproportionation of hydrogen peroxide as in equation $(2)$.

$$\ce{2 H2O2 -&gt; 2 H2O + O2}\tag{2}$$

Hydrogen peroxide is a reactive chemical that cannot be stored forever, but the direct disproportionation path is not typically what degrades it. However, you can add $\ce{MnO2}$ to it. Upon addition, oxygen gas vigourously bubbles out of the solution. In this case, there was a kinetic barrier impeding the direct transformation due to reactants and products having different multiplicities (oxygen gas’ ground state is a triplet, all others are singlets). The $\mathrm{d^3}$ ion manganese(IV) is a radical itself that can partake in different radical reactions, allowing the diradical oxygen to be liberated.

Selectivity

This is exceptionally true for transition-metal catalysed organic carbon-carbon bond formation reactions. Note first that the action of a catalyst is frequently depicted as a catalytic cycle: A reactant reacts with the catalyst to some intermediate species, this rearranges or reacts with other reactants/additives/solvents in a set of specific steps until finally the products are liberated and the catalytic species is regenerated.

Many such reactions require organic halides as one of the reacting species. And the first step is typically an oxidative addition as shown in equation $(3)$, where $\ce{X}$ is a halide ($\ce{Cl, Br, I}$).

$$\ce{R-X + Pd^0 -&gt; R-Pd^{+II}-X}\tag{3}$$

Palladium typically prefers oxidatively adding to bromides or iodides and tends to leave chlorides alone. I myself have performed a reaction with near-quatitative yield in which a reactant contained both a $\ce{C-Br}$ and a $\ce{C-Cl}$ bond — selectively, only the $\ce{C-Br}$ bond took part in the palladium(0) catalysed Sonogashira reaction.

Although I did not try it myself, I am pretty sure that switching to a nickel(0) catalyst species would shift the reaction in favour of reacting with the carbon-chlorine bond rather than the carbon-bromine one.

Mildness

This is basically a reiteration of the first point albeit with different intentions. Many a time in organic synthesis, one has a rather sensitive reactant that would degrade or undergo side-reactions if subjected to standard reaction conditions, such as high pH-value or elevated temperatures. As an example, consider a transesterification as shown in equation $(4)$.

$$\ce{R-COO-Et + Me-OH &lt;=&gt; R-COO-Me + EtOH}\tag{4}$$

This reaction is, of course, an equilibrium and by using methanol as the solvent we can shift it to the product side. For the reaction to happen, one would need a base strong enough to deprotonate methanol, giving the methanolate anion, which can then attack the ester functionality. However, methanolate being a strong (and nucleophilic) base itself can introduce undesired side-reactions, including epimerisation of the &#x3b1;-carbon.

One can catalyse this reaction by using $\ce{Bu2SnO}$, which will activate the carbonyl group, making it more susceptible to a nucleophilic attack. The reaction speed is the same but the conditions are milder (no additional base required) and the number of side-reactions is those strongly limited. In particular, I noticed no epimerisation of the &#x3b1;-carbon in the tin(IV) catalysed method.