Go on Avid’s website and use the dealer locator to find the reseller (dealer) nearest you. Call them and arrange a demo of Avid 3D. They’ll walk you through the program and show you some of the things that can be done with it. Make sure you get some “stick-time” (an aviation term), meaning that you sit down and play with the software yourself. Often times, the dealers don’t want you touching anything, they just want you to sit, watch, go “ooooo!” and buy. Make sure they give you a chance to play.
From what you’ve described, it sounds as if Avid 3D might fit your needs, but again, only a demo can tell you for sure. If you’re looking to do advanced character animation, for example, then look at a bonafide 3D-application, such as softimage, Maya, 3DS Max, Lightwave, etc. If you’re looking to create and add simple 3D objects to your video, as well as create simple 3D animation, 3D lights, particles, text, explosions, warps, and other 3D FX, then Avid 3D should fit the bill.
I use Avid 3D and I love it…provided I’m using it for the manner in which it was designed. It’s a great tool and the learning curve is actually quite tolerable. Go on Avid’s website and check out some of the online tutorial/demo’s done by Tim Wilson (former “Man About Town” at Boris, now working at Avid). Tim is very competant and a good guy to boot. I’ve been learning from him for years…and you can too. Check it out, but make sure you have the Flash Player installed: https://www.avid.com/video/xpressDemos/index.asp?currVideo=1
Dealer locator: https://www.avid.com/forms/locator.asp
Good luck.