Text titles like in tv shows, After Effects or another software?
After Effects is professional software for creating motion graphics, and can do what you are asking. There are a plethora of plugins, scripts and presets available to make it even easier, but out of the box it is very powerful software.

AE can also be scripted using Adobe's Extendscript scripting API. Within compositions (the name for the sequences created in AE) individual elements can be controlled by expressions. Both Extendscript and expressions are javascript-based.

For titling a show the workflow would depend on the content. For say a regular show the best approach would be to create templates. Adobe Premiere works very well with After effects, so that templates can be re-purposed within Premiere - e.g. the text content of a lower third title can be changed for different people's names.