Just FYI any cheap camera will do, you could even use the video mode on a point and shoot if it came to it, if it shoots at least 640X480 15 fps (you interpolate to get 24 or 30 fps) Remember all you want is the motion not a pretty picture. Light your tracking object well and it won’t much of an issue.
Max has an integrated motion tracker under the utils. panel>more>camera tracker, works pretty good to be honest, although I don’t think it has seen any update for ages…
I mostly use After effects, as I am used to it, and it works well. The new CS4 has Mocha built-in, should be nice.
Fusion has a great tracker built in too.
If you don’t have either AE or Fu, Pixel Farm has a nice 2d tracker for like $100 Pfhoe & Pfhoe Pro $150, I believe, I haven’t used it only watched the demo vids but looks nice-n-easy to use.
PixelFarm also has a 3d tracker but it is super expensive…
And to add Ky_trails & Ghostrails are sweet, and you can find out more about Ghostrails Here, they do have a demo and it is way more worth than the cost:)