I see that you've excluded Adobe After Effects from the list. I use it and it's great, hard to learn, indeed, but I belive it's one of the best. I use a combination between Sony Vegas and AE, anyways, if you wish to see some tutorials here's a pretty good site (After effects only).
http://www.videocopilot.net/tutorials.html
Good Luck!