I agree that if what you want is some concrete information that the subject is reluctant to give up ("Where have you buried the guns I need in order to kill the rest of your family?") -- you could probably get at that via torture. I don't know if that would typically be the fastest or most reliable way to get that information (Consider, eg: Staging an escape, allowing the subject, helped by an under-cover agent, point you to said guns).
I think people get hung up on the "bomb plot theory" too much. My impression is that while such simple cases make for great TV, that's not the kind of real-world questions intelligence organizations really are concerned with. So if we say: "ok, use torture to save the children!" -- if that was taken at face value -- it means: "Disband most (all?) large-scale operations that allow torture today, such as the CIA programs."
I also think there's a bit of a hang-up on "effectiveness". If you're fighting an illegal war, kidnapping and killing people that are clearly innocent -- it's hard to accept an argument from "effectiveness". At least if there's no indication that atrocities would stop if you "won".