This thread might be a tad old, but I'm just adding my two cents for anyone that is still interested.
Generically speaking, there are 2 independent notions that can be defined on a (Riemann-Cartan) manifold:
1) The metric, for determining infinitesimal lengths
2) The connection, for determining parallel transport. (Note that parallel transport is determined in its entirety. This includes the possible effects of there being rotation of a vector when parallel transported)
While we're at it, we can also determine the covariant derivative of the metric,
Q_{\mu\nu\rho} = \Delta_\mu g_{\nu\rho}
This is the non-metricity tensor. One can work with manifolds where this tensor is non-zero.
If, however, Q =0 then that means that under parallel transport, infinitesimal lengths and angles are preserved under parallel displacement. Also, this is the condition for local Minkowskian/ Euclidean structure to be valid. If the nonmetricity tensor were not zero, one could not presume that the manifold were locally Minkowskian/ Euclidean.
The Levi-Civita connection, on the other hand, is the special case of the (locally Minkowskian) manifold which has 0 torsion. This need not be so at all in more general manifolds. In fact, in a torsion-free locally Minkowskian space, one can go to the non-coordinate basis (or the tetrad) locally, not by a coordinate transformation, but by postulating that we have such a basis and that we can express it in terms of the coordinates at the point being considered (as every vector in a linear space can). Hence, the tetrad field is nothing but the coefficients of these linear combinations.
Notice how, when the metric is reduced (locally, i.e. at a point, not in an open set about the point) to the Minkowskian form, we can also make it such that its derivatives = 0. So, if we were to do this in "standard" GR, where we work only with locally Minkowskian, torsion-free manifolds, we'd get the connection to be 0 (because the connection, which is the Levi-Civita connection in this case, is determined entirely by the metric and its derivatives). That such a transformation is indeed possible (making metric trivial and derivatives =0) is a non-trivial proposition, and a good (sketchy) proof is given in the book by Carroll. (on pgs 73-74)
While it is possible to get rid of the connection in this manner in standard GR, we do not get rid of the curvature because we do not have enough "degrees of freedom" to remove the second derivatives of the metric as well.
Now we return to more general spaces. While in standard GR, the connection = 0 locally, in spaces with torsion, it is not possible to get rid of the connection. This is because the connection also depends on the torsion tensor (the dependence is denoted by \gamma_{\alpha\beta\gamma} [\itex] in one of the posts above). For non-zero torsion, the local connection does not vanish, even though the metric is locally Minkowskian. This is the origin of the spin connection.<br />
<br />
It is possible to connect spinors to GR (and potentially describe rotating black holes with spin and mass) which is not possible to do easily with the usual coordinate basis. For those interested, there is an excellent article in Rev. Mod. Phys. by Hehl et al. The link is here:<br />
<a href="http://rmp.aps.org/abstract/RMP/v48/i3/p393_1" target="_blank" class="link link--external" rel="nofollow ugc noopener">http://rmp.aps.org/abstract/RMP/v48/i3/p393_1</a><br />
<br />
A very good exposition in my opinion and definitely worth reading even if you are mildly interested.<br />
<br />
We now return to the tetrads and can attempt a sort of conceptual understanding of things. In spaces with torsion, we clearly have more degrees of freedom. If we parallel transport a vector on the manifold, and it rotates, then this degree of rotation yields these additional degrees of freedom. The so-called integrability conditions are then a measure of "non-commutativity" of the tetrad basis - what happens when we transport one way and then the other? So, in answer to one of the earlier questions - there are now additional degrees of freedom - in addition to the specification of the metric, we'd also need to specify the torsion (or the spin connection)<br />
<br />
It is of historical interest to note that what the Cosserat brothers (and henceforth adapted to GR by Cartan) did was to assume that any elastic medium had not just the displacement field, but also a rotation field. Assume we had a perfectly (linearly) elastic, isotropic body, obeying Hooke's law. If we stretched it in one direction, the usual laws of elasticity would determine the displacements in the transverse directions as being equal (depending on the Poisson ratio). If, in addition, the medium were such that at each point a local moment were present (as opposed to just a non-zero force density) then we'd clearly need to describe the response of the body to an external moment. So we'd need further constitutive relations in addition to Hooke's law for determining the complete state, which now contains both the displacement field and the rotation field (rotation at each point)