After mentioning Kino, Joe Brockmeier wrote a timely article on "How to create video titles and graphics with Kino" over at Linux.com. Whilst it is definitely not as easy as Apple's iMovie but nothing beats free and open source, right!?!
I urge you to try it out and see if you like it. I am hoping that you would and eventually consider helping out the Kino project by providing some of your coding hours. I hate to see one single open sourcetool to dominate the market – choice is important. :)