How can I add animated text to a video programmatically (from a script) for use as quality video introductions?
Get TypeMonkey for AfterEffects. Other than templates, it's the easiest way to generate text animations from scratch. 

http://aescripts.com/typemonkey/