Videomaker – Learn video production and editing, camera reviews › Forums › Specialty Topics › Special Effects › Video particle effects software › Basically Adobe After Effects
Basically Adobe After Effects is a industry standard for motion graphics. There is no real alternative for this program. It is really expensive but gives you HUGE possibilities. It is used to produce VFX, opening titles and more in many blockbusters (in Iron Man 3 all HUD elements were created in After Effects).
However you may try HitFilm which is basically a cheapo copy of After Effects http://hitfilm.com/ . Short movie's Prism VFX were all created in it (check out Prism here http://www.youtube.com/watch?v=9QoNouEfjuo ). It does not have such amount of free tutorials, plugins and possibilities overall BUT it still does a job.
But it really depends how deep do you want to go into these type of stuff.