Check out William Sutton's motion capture tutorial.
I'm not a big mocap fan myself either. I think it's great for sports/fighting games and crowd scenes, and the hybrid mocap/keyframe technique used on Gollum was amazing but for the most part, I'm a "give me keyframes or give me death" kinda guy.
But as I mentioned earlier, the files are very educational. It's like holographic reference and you can examine the motion curves in minute detail.