In reply to The Lemming:
as rich said, as a starting place, browse youtube for intros you like and see if you can identify the elements of the intro you like. can you recreate them in PP elements?
aftereffects is probably the tool of choice for this type of thing but it is pretty expensive, however what you could do if you have the time is...
swot up on training videos (both general AE videos and how to's for particular effects) and then when you are ready to start, download aftereffects as a one month trial and then work like a demon to make your intro, render it out as a video clip and then just add it as a normal clip to the start of all your future videos. however be warned... creating interesting intros is a progress, and requires a lot of time and practice... a one month trial might not be enough if you have other thinks in your life... you know like sleeping or eating or even a job
I don't know exactly what PP elements actually gives you but you may be able to create some cool effects just by animating text and blank areas (masks) over text to make it interesting.
many TV shows actually have pretty simple intros if you tackle each section of it as a separate element and build it up bit by bit.