The other answers give good insight. Here's another perspective.
Since the Levi-Civita connection is the unique metric and torsion-free connection, to motivate its use we need to convince ourselves that both of these properties are desirable. I'll note that there is sometimes value in considering non-metric connections, but in the question you addressed why using metric connections make sense for studying geometry. So I guess the real issue is to tackle torsion-free-ness.
In order to address this, the first thing to do is try to understand what torsion really is anyway. There is another question on Mathoverflow about torsion with some great answers, but let me try to draw some pictures. We'll start with the standard picture of the curvature tensor (for a torsion-free connection). (Edit: I got several comments about how to interpret these pictures. I'll discuss this at the end of the answer)
The idea is that we have three vectors $X$, $Y$ and $Z$. Starting at a point $P$ in our space, we use our connection to parallel transport $Z$ an infinitesimal amount along a geodesic in the $X$ direction and then along a geodesic the $Y$ direction. We then parallel transport $Z$ in an infinitesimal amount in the $Y$ direction and then the $X$ direction. The curvature measures the difference between these two parallel transports. In the formula, the Lie bracket term is there to make sure that everything is nice and tensorial.
What changes if the torsion is non-zero?
In this case, if we parallel transport in the $X$ then $Y$ directions versus the $Y$ then $X$ directions, the infinitesimal square doesn't close up, and what remains is the torsion. Again, in the formula there is a Lie bracket term to make everything nice and tensorial.
So why do we want a torsion free connection?
In my opinion, torsion is complicated invariant and is somewhat hard to understand. For curvature, there is a very clear picture of what it means for a space to have positive versus negative curvature (infinitesimal planes coming together versus spreading apart). As such, it's possible to formulate all sorts of theorems in terms of curvature assumptions. On the other hand, torsion is this awkward vector that you get when you compute multiple derivatives. It's not really meaningful for it to be "positive" or "negative," and so it doesn't affect the analysis in predictable ways. As such, life is often a lot easier when it's not around, and is what makes the Levi-Civita connection so useful.
I should add that there are times where considering connections with torsion makes sense. For instance, on a Lie group it is possible to construct a curvature-free connection whose torsion encodes the Lie algebra. This is a very useful connection, but from an analytic perspective, it's not so clear geometrically how the respective torsions of $SO(3)$ versus the Heisenberg group (for instance) give rise to their very different geometries. Another example is in non-Kahler complex geometry, where we can study holomorphic, complex, metric connections, which must have non-zero torsion. But again, even though the torsion is present and necessary, it's often hard to really use it in a meaningful way.
How to interpret the pictures
There were several comments about what the pictures are conveying exactly, so I should say a few words about what they mean.
When I first learned about the concept, I found it helpful to use the diagrams as a schematic without worrying about which particular fiber everything is defined in. You can still use the diagram to see that the curvature and torsion are skew-symmetric in $X$ and $Y$ and that the curvature is a (3,1) tensor whereas the torsion is a (2,1) tensor.
To make the picture more rigorous, we either parallel transport in the direction $X$ by a distance $\epsilon X$ or, (as shown in the picture) we make $X$ a tangent vector whose length is $O(\epsilon)$. We do the same thing with $Y$. On the other hand, we assume that the norm of $Z$ is $O(1)$. To obtain the diagram, we rescale the geometry by $\frac{1}{\epsilon^2}$ and let $\epsilon \to 0$. As Robert Bryant noted, for non-zero epsilon, the $XY$-parallelogram in the first picture does not fully close, but the displacement is essentially $R(X,Y)(X+Y)$, which is $O(\epsilon^3)$. When we rescale and take limits, this error vanishes, which is why the parallelogram closes in the picture. The fact that this picture is infinitesimal in $X$ and $Y$ is also the reason why the geodesics are drawn as straight lines.
If we want to make everything completely rigorous while keeping track of the various tangent spaces and making sure that the final expression lives in in $T_p M $, things get really complicated. I'll write it out for the curvature, and it's possible to do something similar for the torsion. To do this, we can define the transport function $Tr(p,X,Z)$ to be the parallel transport of $Z\in T_p M$ to $T_{\exp_p(X)}Z$. Then, in terms of the transport map, the exponential and logarithm, we have the following expression.
$$R(X,Y)Z = \lim_{\epsilon \to 0} \frac{1}{\epsilon^2} Tr\left [ \exp_{\exp_P(\epsilon X)}( \epsilon Y),\log_{\exp_{\exp_P( \epsilon X)}(\epsilon Y)}(P), Tr(\exp_p( \epsilon X), \epsilon Y, Tr(p,\epsilon X,Z))- Tr(\exp_{\exp_P(\epsilon Y)}( \epsilon X), \log_{\exp_{\exp_P(\epsilon Y)}(\epsilon X)} (\exp_{\exp_P(\epsilon X)}(\epsilon Y)),Tr(\exp_p(\epsilon Y),\epsilon X, Tr(p,\epsilon Y,Z) ) \right]$$
I think the pictures are much more meaningful and intuitive than this expression, even if it's a bit harder to interpret them rigorously.