Many factors that go into this so its not always going to be a hard yes. What IS usually a hard yes is that with flagship CPU's, the top of the range high power output models, a big AIO is generally going to keep the CPU cooler for extended high load use cases.
Outside of that, often its more of a formfactor, personal preference or sound based decision. Does this mean air coolers are better? No. Water coolers? No.