do you have Keynote (Mac version of Excel)? That helps with transitions and such, but still pretty limited.
The new imovie in ilife 11 or whatev looks like it has better canned transistions but I still think they suck for making quality vids. If it's just for personal home stuff, imovie does all you need. Otherwise do what _33 said.
I'm really cheap with this stuff.