Well since they're not many video making threads, I just want to leave this thread with my experiences on good Video Editing Software.
--------------
For Mac:
Basic:
iMovie
iMovie HD
A simple program to do editing on. I'd recommend these programs for you if you don't excessively need to video edit or use strong effects.
Intermediate:
Final Cut Pro
Final Cut Express
These two are great video editing programs that can edit video very well and it is very broad. These programs are for more of the serious editors.
Advanced:
Adobe After Effects (works for PC too)
Used by professionals, this program takes a lot of time to get your grasp upon. The complexity of this program is huge. What you can produce from this program is amazing.
PC:
Basic:
Windows Movie Maker
A easy to use video editing software which is great for basic video making. Learning Windows Movie Maker isn't too hard.
Advanced:
Sony Vegas Pro 9.0c
A very complex editing software similar to Adobe After Effects which is highly recognized and used by film makers.
---