Please let me first refer you to the following review by I. L. Shapiro, which contains a lot of theoretical and phenomenological information on spacetime torsion. The answer will be mainly based on this review.
In the basic Einstein-Cartan theory, in which the antisymmetric part of
the connection is taken as independent additional degrees of freedom, the torsion is non-dynamical: (apart from a surface term which does not contribute to the equations of motion).
In the following, only minimal coupling to gravity will be considered (in which the flat metric tensor is replaced by the full metric tensor and the derivatives are replaced by covariant derivatives). There is a huge number of suggestions for nonminimal couplings in most of which the torsion becomes dynamical.
The torsion contribution to the gravitational part of the Lagrangian is quadratic in the torsion components, please see Shapiro equation: (2.15), where the additional terms to the torsion can be more economically expressed using the contorsion tensor whose components are linear combinations of the torsion tensor:
$$ K_{\alpha\beta\gamma} = T_{\alpha\beta\gamma} -T_{\beta\alpha\gamma}-T_{\gamma\alpha\beta}$$
A scalar field minimal coupling to gravity, does not require covariant
derivatives because the covariant derivative of a scalar is identical to its ordinary derivative, thus the scalar field Lagrangian does not depend on the torsion, therefore in the case of a scalar field coupled to gravity, the torsion remains sourceless, and the its equations of motion imply its vanishing.
When the Dirac field coupled to gravity with torsion, the Lagrangian can be written in the following form
$$\mathcal{L} = e^{\mu}_a\bar{\psi}\gamma^a (\partial_{\mu} -\frac{i}{2}\omega_{\mu}^{cd}\sigma_{cd} )\psi + e_{\mu a} K_{\alpha\beta\gamma} \epsilon^{\mu\alpha\beta\gamma} \bar{\psi}\gamma^a \gamma_5 \psi$$
($e$ are the vielbeins and $\omega$, the torsionless part of the spin connection, they both do not depend on the torsion).
Taking the variation with respect to the contorsion components, we obtain an algebric equation of motion for the contorsion tensor:
$$ K^{\alpha\beta\gamma} = \frac{\kappa}{4}e_{\mu a} \epsilon^{\mu\alpha\beta\gamma} \bar{\psi}\gamma^a \gamma_5 \psi$$
($\kappa = 8 \pi G$). The last term in the Lagrangian is just of the form:
$$\mathcal{L_K} = K_{\alpha\beta\gamma} \sigma^{\alpha\beta\gamma}$$
Where $\sigma^{\alpha\beta\gamma}$ is the intrinsic spin part of the Noether current corresponding to the local Lorentz symmetry:
$$M^{\alpha\beta\gamma} = x^{\alpha}\Theta^{\beta\gamma}-x^{\beta}\Theta^{\alpha\gamma}+\sigma^{\alpha\beta\gamma}$$
$\Theta$ is the stress energy tensor. This example shows that for the Dirac field, the torsion source is the spin tensor.
As can be observed, the torsion couples axially to the Dirac field. This type of coupling is known to produce anomalies. A careful analysis shows that in the baryonic sector, the same anomaly cancellation criteria of the standard model lead to the cancellation of the axial anomalies due to torsion as well but not in the leptonic sector. This is one of the difficulties of this theory. One possible solution is to absorb the torsion contribution into the definition of the axial current. In contrary to the gauge and photon fields, where this contribution is not gauge invariant, since the torsion field is not a gauge field, this redefinition seems possible. This seems also consistent with the Atiyah-Singer index theorem which states that the anomaly density must be equal the Pontryagin class which is a topological invariant, while torsion can be introduced without altering the topology.
There is another difficulty related to the torsion coupling coming from the fact that the torsion couples only to the intrinsic part of the fields:
In the case of gauge fields such as the Maxwell field. The intrinsic spin is not gauge invariant and only the sum of the spin and the orbital angular momentum is gauge invariant. Thus, although the minimal coupling leads to a coupling of the torsion to the intrinsic spin, the gauge invariance is lost. The following recent article by Fresneda, Baldiotti and Pereira reviews some of the suggestions to overcome this problem.
Best Answer
I would be very careful with the phrase "gravity is the manifestation of curvature". Because if one falls towards a massive body --- this observation is typically associated (by laymans) with gravity --- it is actually not a symptome of curvature, it simply might mean that one is in a "wrong" coordinate/reference system that provides one this impression.
However, if one includes in the concept of gravity the occurrence of tidal forces, then one could indeed attribute that to curvature. In this sense one could say: "gravity is the manifestation of curvature".
Actually I would prefer to say:
Curvature is generated by momentum & energy (density) whereas
Torsion is generated by spin (density).
The effect of torsion is actually very weak. As the 2. equation (also 2. equation of your post) which links torsion with spin is an algebraic equation torsion cannot propagate. One would find torsion only at places with significant spin density, for instance inside exotic astronomical objects like a neutron star or in the first instants after the big-bang.
Under the assumption that the torsion tensor is totally antisymmetric, autoparallelism equation and geodesic equation are the same. Therefore the torsion would not influence the motion of a particle in a place of high spin density. The only effect torsion produces is spin precession. So one could tentatively say: Spin precession is a manifestation of torsion. But as there are other effects that can produce spin precession --- and mostly probably stronger than the one generated by the torsion --- one should be extremely careful in the expression of such an assertion. Because the effect (spin precession) and the concept (torsion) are not uniquely related.
The most pursued approach in handling with torsion is to try to eliminate it from the equations, because torsion makes the math quite complicated. In this respect there would be no manifestation at all.