Air coolers and liquid coolers are pretty equitable in performance, in their respective areas. The thin 120mm coolers are @140w, and do the same job as the 140w budget coolers. And this goes all the way up to the largest aircoolers such as the 250w+ Noctua NH-D15S and 240mm/280mm liquid coolers. But thats where it stops. It's limited by the sheer size of the big twin towers vrs space around the socket and above a gpu. The 280mm liquid coolers have a capacity approaching 300w+ as do the 360mm, 420mm and massive 480mm coolers. But for anything 250w ish and below, air = aio.
Before jumping into buying anything, there's one question that absolutely must be answered. Just how hard do you plan on punishing the cpu. For some, that means high-extreme OC. For some it means massive thread usage during extended periods of production software such as rendering or compiling.
You can't over-cool a cpu with a standard mechanical cooler. No matter what limited usage there may be, bigger is better. If for no other reason than with greater capacity comes lower rpm fans and less noise. A NH-D15S on a stock i7-8700k under nominal usage is for all intents silent. A CM hyper212 evo on a i7-8700k under nominal usage is pretty loud.
That Carbide 275r will fit most aircoolers with 170mm of clearance, and any aio upto 360mm. So, your cooler choice is limited realistically by 2 things. Budget and usage. Just how hard do you think you'll ever push it?