I love making WoW movies but I still haven't managed to find the best program to handle both audio and video tracks all together.
In particular, I am looking for something that does the same thing as this : http://www.trapcode.com/products_soundkeys.html , however avoiding the use of Adobe After Effects which i find pretty much bulky and not very much user friendly.
My goal is to make some movies that have some sync'ed effects or animations with the music (like say the bass drum pounds and the video zooms in and out, or some mad guitar solo going on and the video blurs etc etc) , in an *automated* way , meaning that i do not want to do all the stuff myself frame after frame.
Can anyone help me on this?

I prefer using Adobe Premier ( http://www.adobe.com/products/premiere/ ) to handle editing. It allows you to manipulate multiple video and audio tracks and perform basic effects with them, though it isn't as specialized as After Effects is for graphical/visual effects.

I'm not sure there are programs that will automate your video to your music, though I may be wrong there. In my experience it's all manually done.

sony vegas is pretty handy, I think its a bit more user friendly than premiere. Also Fura(the mage from curse) has a pretty handy short vidoe guide on using it an fraps somewhere, you can proabaly fidn it on the curse forums.

I haven't ever see a program that would do that in an automated way, let me know if you find one though, that'd be neat