[Jonny Webb]"So have you seen the TV show Big Bigger Biggest. Its very popular, partly i'm sure, for the cool animations. They have a blueprint look and feel, just wireframes, but smoothly animated. And i've been asked to put one together "if it doesnt take a week". At work i have access to CS6 AE, CS6 PPro, and 3DS Max, maybe others."
Those are animated 3D models, and they'd have to be done in a 3D application like Max.
How long it will take to do depends on how well you know your 3D app, how good your modeling skills are, and how complicated the object you have to model is. You may be able to save time by finding a stock 3D model for the object you need on a site like TurboSquid.
Principal & Designer at Keen Live
Motion Graphics, Widescreen Events, Presentation Design, and Consulting RenderBreak Blog - What I'm thinking when my workstation's thinking
Creative Cow Forum Host: Live & Stage Events
Depending on what exactly you need to include in your title sequence- what kind of objects you need + text, you may be able to use a plugin like ShapeShifter. For more complex 3d objects you can also use Zaxwerks Invigorator Pro. Of course the most direct way would be to do it in a 3d app, but I think AE can achieve a similar result using only 3rd party plugins like the one I mentioned above.