Now the argument in favor of the MSE.
Consider a Loss/Cost function due to deviation, $L=L(d)$. We want it to have certain reasonable properties to do the job it is meant to do.
One such property is $L(0) = 0$.
Another is that $L(0)$ is a global minimum. But then, and if it is differentiable at $d=0$, we will have $\partial L(0)/\partial d =0$, but also $\partial^2 L(0)/\partial d^2 >0$.
A third condition is that it is everywhere increasing in $d$.
Consider now its 2nd-order Taylor expansion around zero (McLaurin):
$$L(d) \approx L(0) + \frac {\partial L(0)}{\partial d} \cdot d + \frac 12 \frac {\partial^2 L(0)}{\partial d^2}\cdot d^2 = \frac 12 \frac {\partial^2 L(0)}{\partial d^2}d^2$$
...since the first two terms are zero given the properties we want the function to have. Also, the last term is positive, and depends on the square of the deviation, so it is symmetric for negative and positive deviations.
We conclude:
If as our Loss function we can use a function differentiable at $d=0$, then the deviation cost (especially for small deviations) can be acceptably modeled as a linear function of the squared deviation.
This looks like a very general and powerful argument in favor of MSE in all cases, but there are two subtle and critical points that weaken it:
1) Differentiability at $d=0$ is exactly what is lost in most cases where the real-world situation indicates that costs are asymmetric for negative and positive deviations.
2) To move from "squared error" to "expected squared error" we must consider $L(d)$ as a random variable. But then, whether one will use $E[L(d)]$ or some other "measure of concentration", becomes debatable and open to arguments, theoretical and applied.
Here is where the convenient properties of the expected value come into play, being a linear operator in theory and being estimated by sample means in applied work.