Personally I think MediaStudio Pro is very good. It is though a fully featured editing package. You can decide for yourself if it is suitable for you, by downloading the trial from
http://www.ulead.co.uk/msp/runme.htm and click the Trial button.
If you want to check out one example of what can be achieved then check the post at
http://www.videoeditingforums.co.uk/viewtopic.php?t=328
In addition Marc Peters has a summary of all the main editing players. Check out his post to research the package that is right for you.
http://www.videoeditingforums.co.uk/viewtopic.php?t=548