I agree with Russ. I run FTM 2012 all day, every day with little problem. I don't have an enormous file (abt 2500 people and a file size of 14 Meg). I generally keep media separately except for unusual items that I want to share with the Ancestry community. I used to work in software development and user support and from that experience I feel fairly certain that the problems here are experienced by a small number of people and the vast majority of users experience little problem.
Of course, EVERY problem brought to these boards is important and there are some very real issues with parts of the program. I'm not downplaying any of these at all. I find that I frequently can't reproduce the problem with my database but that just means I don't have the right set of conditions to cause the problem to recur for me.
I still feel you should "dip a toe in the water" with, perhaps, a small subset of your database to get a feel for how FTM 2012 works. After that, it's your call as to what software you use.