Ulead Video Studio is surely what you want. You can add sount and text flying and appearing from where you want and running out how you like as well as user friendly as you prefer.

You can download it from here

Edit: http://Edited link...no you can't as it contains a keygen. This is a violation of our forum rules.

~Crabbyappleton