My group is half way through Book 5 of Legacy of Fire and I have to say I really enjoyed the AP (Although, I love the Arabian Nights genre, Kingdoms of Kalamar/Al-Qadim). Since this and Kingmaker (currently on Book 3's end) were my first shot at DMing a large campaign, I wasn't too savvy on reading through the whole set of books before hand looking for pitfalls, spicing it up for my group... I do not want to fall victim to this again and want to provide my players with a epic campaign. What I am asking of you the community is to provide me with some good Adventure Paths/Campaigns that are heroic and epic in nature. I currently am thinking Red Hand of Doom by WotC, War of the Burning Sky by ENWorld, Scales of War by WotC (ran this halfway through using 4E and will require alot of work fixing some of the assumptions/pitfalls and conversion). I do not want to run Rise of the Runelords and Curse of the Crimson Throne as I have played in these and so has most of my group or Jade Regent as we will be playing this after Kingmaker. So, as you can see I am looking for something that places the party in the path of a war about to happen and they are the heroes that can save the day by digging deep inside themselves. Also, the information has to be attainable (still in print or available on E-Bay) and not too expensive.
Well if you are looking for epic scale the in progress Slumbering tsar series here is pretty epic. Though it doesn't involve a war. And since it is an active campaign, frog god games has their own forum where you can check for what pitfalls or issues others have run into and ask questions. I think that is probably your best bet, choose another paizo AP or something else that is well supported, so you have a place that is active to ask about it since you are worried about running into pitfalls you missed when reading the adventure.