if you're not looking to do anything too advanced, you'll find the two cheaper versions of vegas have good results, lots of easy-to-apply effects and fades, does watermarking and is very easy to add graphics to videos.
http://www.sonymediasoftware.com/pro...egasfamily.asp