Video Editing Software of Choice?

Adobe After Effects is a good choice if you have the time to learn the software, it's one of the best on the market.
Sony Vegas is also a very good software and much more simple than Adobe After Effects, but you can still do a lot of the same things with time.