The movement of your camera is going to be significant factor in how you approach tracking things into a scene. Taking some time to analyze (or plan ahead) what is happening with the camera movement will impact how you approach things. Motion can actually handle all of the examples in the video (of course), but other shots may need additional tools. Using the examples on the website.
New York: This is basically a position track, probably the easiest one one. For this you would just do a match move, track the position and then offset the text on Z to simulate the Parallax. Easily handled in Motion.
Bozeman: This is a dolly (position) with a bit of paying (y rotation). Pretty simple to fake. I'd track something at the depth I want to simulate. If i want to track the stump in the middle I'd follow a line down on Y and track a point there, there's a small triangular rock that would work well. After doing the match move track I'd then approximate the pan by rotating the text (or a camera) on Y. Remember if you use a camera you need to lock your background footage. Just put it in a 2D group.
Munich: This is where things get tougher but there's a simple solution, 2 Match move behaviors. The camera moves down on Y and forward on Z. Breaking it down, like the Bozeman example, find a point at the depth point you want to match and track that. I'd then set the behavior's Direction to vertical. Next I'd use another Match Move behavior to track the scale. This will simulate the z transform.
In the Kitchen: This one is a bit more work and where you might want to start to consider other tracking tools (camera matching). That said, Motion will still work here. The camera is panning so you could track a point on the board for the basic position and then manually adjust the rotation.
Once you get beyond these, you may need to look into other tools that will work with Motion. There are 5 camera tracking software options you could look into for working with Motion. Mocha, Syntheyes, PFTrack, DriveX and Blender. Depending on your budge, time and needs, each has advantages and disadvantages. The first three each have export options to Motion project files. For Blender there's a script available online. Dedicated tracking software is a good option for more complex camera matching shots (the camera moves on multiple axis and rotates). All would work with drone footage, and if you are going to be doing lots of this type of work and have the budget, it may be worth picking one up. I'd also recommend you take a look at this http://www.fcp.co/final-cut-pro/articles/1684-an-introduction-to-motion-tracking -concepts. It gives a good overview on tracking options and approaches.
