I love Fusion Pro for shorter and relatively simple runs. For longer, more complex jobs, or jobs with extensive bindery that are likely to require a lot of reprints, my workhorse is a 9-year-old version of Kodak's Darwin Pro.
I evaluated XMPie a year ago, and while I loved the product from a design standpoint, the desktop version had some serious limitations from a production perspective (e.g., no support for batch printing, no quick and simple way to reprint sequential records) and the server version runs into some big bucks.