Really depends on what level of editing you need to do or want do.
Basic simple editing I think Sony Vegas is enough.

But if you want more complex and nicer effects, you can get Adobe Premier Pro.
And if you need even more special effects, you can get Premier Pro along with After Effects since the editing file can be worked on both platform.