Sebastian König gives a great 7-minute demo of the upcoming camera tracker functionality in the Google Summer of Code project.
Here's a quick demo of the tracking workflow in Blender, as it was this morning. But it already got better by now. :D Hard to keep up with development. This is becoming a serious alternative to other (commercial) trackers. When GSOC is over, we've got a mature tracker right there.