For lots of free stuff (music, graphics and animations) sign up with Digital Juice – Once you do they have a fairly large amount of goodies available for free.
If you can spring for a few $$$, I love Bluff Titler – For the money (around $50) it really does a superb job. If not, you could always create something in any graphics program you have (Photoshop, Illustrator, Corel Draw, Paint Shop Pro, etc…) and play with it in your NLE.
If you intend to do this on a regular basis, it would be best to start investing in some decent royalty free assets (music, sounds, stock footage, animations, graphics, etc…) and some software to go with.
