Depends on what youre doing exactly. I use After Effects and 3DS Max everyday... If its simple text (2D) with some cool transitions, etc, use AE. If you need something 3D use 3DS Max or another 3D package.
You can do some great stuff with AE with very little work using the built in presets. Have fun!