Air cooling is hands down the best for the money. The limitation is, your surface area (ie cooling capacity) is limited by the weight / size of the cooler. You can dynamically increase 'surface area' of the air over the cooler with more air flow (poor noise to performance ratio).
Watercooling can increase surface area as far as the case can support radiator mounts (unless you choose to mount radiators outside the case) and can increase 'surface area' of the liquid over the CPU block through increased flow rate. Pump noise is an issue depending on what pump you use). Unfortunately, you rapidly reach a point of limited return for your $$$. The real advantage is the noise to performance ratio.
AIO's generally don't cool as well as a good air cooler mostly because they suffer from poor flow rate.
Asus Prime Z370, Intel 8700k @5.0Ghz, Nvidia GTX 1080 Ti, 16GB @3400 CL14, Watercooling: x2 MCP355 pumps, x1 280 on front of case, x1 360 on top of case, x1 140 on back of case, x1 240 on bottom of case
Last edited by StAndrew; 11-06-2019 at 07:33 AM.