Title slides - animated transitions - what program to use?

I'm pretty much a video editing noob. I have the basics down using Premier and Final Cut...importing video, editing, inserting transitions and title slides. But now I want to take it to the next level. I want to create animated title slides to put in my videos. Where do I begin? What program should I use? I have Final Cut Studio 3, so I would like to use that program as much as I can. (Of course I have to learn first...I understand that).

Do you create the slides in another program, render the video and drop in the videos?

This is an example of what I am trying to create
Green DIY Energy Download Page
(scroll towards the bottom)

Any input your guys could provide would be grealy appreciated.

Thanks!

With FCS3, you'll use motion and/or Livetype. You'll want to find some tutorials on how to use those tools effectively tho as they can be a challenge to get exactly what you want.