Jonathan Riley-Smith's "The Crusades: A History" is a pretty complete account of the subject.

For Western clerical opposition, would you settle for opposition to a Crusade, even if it's not one of the famous ones? The Sixth Crusade (1228) was headed by the famously-hard-to-control Emperor Frederick II, who was on very bad terms with the Papacy (in large part because Frederick combined direct rule of Naples and Sicily with indirect rule of most of northern Italy through the Empire, hemming the Papacy in). Frederick II went on a Crusade despite excommunication and papal condemnation of his efforts, and took Jerusalem despite the local Christian clergy mostly condemning the mission due to Frederick's excommunication. Frederick negotiated a peace with the Ayyubid rulers of Egypt that Frederick's forces could have Jerusalem in exchange for a 10 year ceasefire and a cessation to the Crusade. Christian rule was restored to Jerusalem despite the official condemnation of the papacy.