I think that an NH-D15 can come within a couple degrees of an H110i's performance, with beefier exhaust fan and a 140mm+ pusher fan. The NH-D15 S comes with a single "round" fan (probably 140mm) between the towers. Here's a discussion comparing to the H100i :
https://linustechtips.com/main/topic/209147-noctua-nh-d15-vs-the-h100i/
You may also be able to replicate or surpass an NH-D15 performance with a ThermalRight Le Grand Macho or LGM. The LGM RT model comes with a round pusher fan. If you want to buy the duct, you'll order separately for about $8. But either cooler weighs in at 900 grams with no fans attached. The NH-D15 S with its center fan performs to the same temperature and testbed that the LGM does by simply ducting it to the case exhaust.
If you think about the LGM cooler, research your motherboard and ThermalRight's web-page for the "socket 1151 spacer," to determine if you'll need it. ASUS boards provide a plastic frame that functions like the spacer, and I don't know the score with MSI boards. You could use the TR spacer with the Noctua cooler if you can get one for free. The only way to get one for free, though, is to buy the TR LGM.
It's either "heavy metal" air, or bulky push-pull-radiator with more noise. And 900 grams is not such a terrible strain on a decent motherboard, although socket-1151 deserves special attention to assure no damage to the CPU PCB.
If those sorts of little frets worry you, then you can consider the warranty period and MTBF for waterpump etc., the extra moving parts, the possibility of leakage. I think the leakage looms as an over-imagined risk, but you're best to test an AiO cooler hooked up but "outside the box" and maybe in a vinyl tub. I doubt that most AiO buyers/users bother with that. AiO coolers have become better, but air-coolers can match the performance of some fairly good ones.
UPDATE: I didn't answer your question about airflow. It depends on whether you use a dual-fan AiO or a heatpipe cooler. That is, the strategy will change a bit. You're best to mount an AiO at case intake, but exhaust will still work. You would mount the fans on one side of the radiator, either as "push" or "pull." In that top position, follow the recommendations of the AiO instructions. With the heatpipe, want to exhaust as much air as possible through the heatpipe cooler, and use intake fans that exceed the airflow CFM of the exhaust.