The best and ideal opportunity should offer a combination of the three, but this is rarely the case. I agree that it all depends on the rationale or strategic intent of the acquisition. It also depends on the quality of the due diligence. Sometimes revenue synergies are overestimated and then the focus quickly shifts to the cost synergies and ultimately financial synergies when the deal structure is impacted.
Having cost synergies overestimated also happens quite frequently and usually the integration that follows is rocky as it puts both companies under significant pressure.