I recently stumbled across a great site which offers a diversity of free Video Intro Templates.
You simply need to select from one of many of their free templates, adjust the color and the background music, input your text and you are good to go. The video will be available to download at the 'Home' tab.
The site, however, requires a sign-up, which is totally fine if you regard the quality outcomes of the intros. You can also choose premium templates and a HD option for a little fee.
The URL is: Website video creation - create high-end video and animation online in your website browser
I hope you enjoy their service as much as I did.