I had the same question 5 moths ago - I was trying to create 30 second motion graphic for the new scoreboard at Lambeau Field. The best thing I've found is After Effects. There is a learning curve, to be sure, but that can be significantly mitigated through the use of tutorials - I use Lynda.com and haven't seen any better than they have available.
If you can grasp After Effects decently, consider finding a template on a site like Videohive.net and modding it out to suit your needs. There are tons to choose from and they aren't terribly expensive. There are also quite a few free After Effects templates on individual blogs that you may have luck with. some people might see that as a cheat, but they saved me hours of frustration.
Incidentally, these things are not cheap. We were quoted by two firms on (3) 30 second motion graphics for the scoreboard and the cheapest was $6,400.00. The total cost of the Adobe CS6 Master Collection was $599 - I registered for a college course at my local community college to utilize the student discount , but then had to drop it due to schedule constraints but was still able to use the discount (and will be taking it this semester for $380). A Year membership to Lynda.com with example files was another $300. The Videhive template that I modded out cost only $12, but they make it clear that if you use the template for commercial purposes, they would like you to pay for a more expensive license granting those rights - $120 in my case.
$599 Total cost of software (which includes the rest of the Adobe CS6 Master Collection),
$300 tutorials ( a year membership to Lynda.com! )
$120 Full License to a template.
$920 Total for a graphic. A software suite and a year of tutorials included.
I'd estimate I've spent 80 hours on tutorials and template modifications, but I have become reasonably proficient in After Effects and that isn't exactly a skill that wouldn't be easy to monetize if I were inclined /more confident in my abilities. Must complete more tutorials.
I realize I may come off like a schill for Lynda.com or Videohive, but I swear I am just a satisfied customer and nothing more. I am sure there are competing services that are equal if not superior. Maybe there is even a hatcheries.com site for motion graphics where you can host a contest for $250 and have several people produce what you'd like.