Hi petergreat,
Using AdS/CFT to study strongly interacting systems is still in its infancy, but let me give you some of the highlights so far in my opinion. AdS/CFT has provided quite a few qualitative insights. Here are a few examples:
1. The idea that viscosity and entropy density should be strongly related is a product of AdS/CFT. In particular, there is a conjectured bound on the ratio \eta / s (\eta is the viscosity) which is supposed to be bigger than 1/(4\pi). We now know this bound is not true, but it did inspire people to look at this quantity which is very natural from the gravity point of view. The quark gluon plasma at RHIC and cold fermions at unitarity come close to this "bound".
2. AdS/CFT provides a new geometrical picture of confinement. In fact, I've heard many people say that if we hadn't already discovered confinement, we would have learned about it from AdS/CFT. This illustrates one of the key hopes of the AdS/CFT community, namely, that we might learn about qualitatively new dynamical phenomena at strong coupling.
3. AdS/CFT gives a beautiful geometrical picture of entanglement entropy in the field theory. The gravity calculation is incredibly easy compared to the field theory calculation, but I think it hasn't yet led to really interesting progress on the field theory side. However, the interplay of quantum information theory and gravity is just beginning to be understood in the context of AdS/CFT.
4. AdS/CFT really shines in real time transport at finite temperature. These calculations are extremely difficult in the field theory because of subtleties in analytic continuation, etc that arise. I personally think one of the major contributions of AdS/CFT will be to the study of real time response and non-equilibrium phenomena at finite temperature in field theory. But this area is still very young.
I focused on the positive, but AdS/CFT is still a long way from making contact with really real systems. The closest so far may be the quark gluon plasma where some quantitative predictions of the theory may be more or less borne out. Other condensed matter systems still seem quite out of reach, despite the motivations of many people in the field. We best understand translation invariant highly supersymmetric situations at large N, strong coupling, etc, which are relatively far from systems like cuprate superconductors or heavy fermi liquids.
Of course, we are learning a great deal about quantum gravity as well!
Hope this helps.