Lets see (I will only go trough the main crusades and ignore others like the children's crusade, Albigensian Crusade,...):
-First crusade-Crusader victory (Kingdom of Jerusalem and other Crusader states were created)
-Second crusade-Status-quo (Muslims conquered Eddesa, The Franco-German armies failed to achieve any major success, yet in Iberia the second crusade was a great success as they recaptured Lisbon).
-Third crusade-Muslim victory (Saladin manages to re-conquer Jerusalem (And some other cities), The Franco-English armies do meet with some initial success, but in the end fail to reconquer Jerusalem, Richard the Lion-Hearted makes a deal with Saladin so Christian pilgrims can travel to Jerusalem. Richard the Lion-Hearted also does capture Cyprus from the Byzantine empire (as it was noted before), which remains a crusader base, until 1473, when the Venetian republic assumes control over it).
-Fourth crusade-Crusade failure (The crusade ends with the sacking of Constantinople and the establishment of the Latin kingdom, the crusade never even reaches its initial objective (Egypt)).
-Fifth crusade-Muslim victory (The crusade meets some initial success, but is defeated at the siege of Cairo).
-Sixth crusade-Muslim victory (The crusade itself ends with a treaty which allowed Christians to rule over most of Jerusalem, yet this is later reversed, so in the it can be considered a Muslim victory).
-Seventh Crusade-Muslim victory (Crusaders were decisively defeated at 2 occasions, the French king was captured, ransomed and later, he would once again start a crusade).
-Eight crusade-Muslim victory (Lets just say the French king is was a stupid f***).
-Ninth crusade-Muslim victory (The Mamluks fight off the crusaders and the Mongols).
Yep, the crusades sure were not a success story.
They were if you were a Muslim.