Hey there my friend..
How pro do you want it?.. My experience is that less is better

I have used Adobe Premiere and Adobe After Effects a lot and every time I wish I would have used Microsoft Movie Maker
See this video which is recorded and edited on my iPhone4 with the program iMovie. Took me 5 minutes from I stated editing to it was on youtube
http://www.youtube.com/watch?v=YnWh4h51-nY
I like both Premiere and After Effects.. But for most of my needs.. I'll keep it simple using Movie Maker and iMovie :P
And.. I think most of the awsomeness of a video is within the shot itself