I've been using big tower coolers ever since the AthlonXP days. To me this seems the most economical choice. High-end units can easily handle 99% use cases, maybe except overclocked top SKUs under extended all-core load.
I'm not a hardcore oc'er myself, I don't bench competetively, I don't need maximum fps in my games. I have no use for an R9/i9 since I don't run multicore workloads all day. So the advantages of custom water over top-end air cooling are minimal for me. And of course there's the extra cost and maintenance.
I briefly considered AIOs, but the small difference in temperatures - even with unrealistic synthetic loads - doesn't appear to justify the expense. I don't care for the RGB bling either, so the esthetics are of minor importance in my book.
The only drawback of tower coolers (especially dual designs) may be case compatibility and RAM clearance. At least memory issues can be easily remedied by swapping a 120mm fan on the front. Then there's the misconception that efficient air cooling must be noisy. That doesn't have to be the case. All my rigs use a single intake and exhaust fan running at 1300-1500 rpm max - when stress testing - plus a single CPU fan at even lower speed. Only my current Zen3 PC uses a dual CPU fan.
All my systems are barely audible in everyday use and very quiet when gaming. And the temperatures are low