@Janro, It's totally understandable that you wouldn't think it's possible or easy. I really think the biggest thing is not even getting the object into the scene, but getting the camera to stick to the real-life camera.
Although the poor-man's way of working this is to simply examine how you camera moves in the footage and then try to move the object in the same way with the same timing.
@dwsel, I actually referenced that thread, but didn't have a link. Thanks for posting it! I'm not much of a developer myself, and I'm not sure if anyone about has the guts or need to create something that sounds so very complex. Thanks for the info, hopefully someone can get a team together... or I can try Icarus and Ic2An8.