When you fancy diving into the deep end and making some serious videos with effects, export to various formats, and use cool transitions, you'll want to check out Adobe Premiere Pro. For the absolute basic video editing - when you only want to stitch together a few clips - iMovie is more than enough in most cases.
