Depends on voltage, in terms of temps. 4790ks need heavy cooling, especially if you overclock heavily and run the voltage past 1.2.
Do you have a big case with lots of fans? I have a d14, but I only ever used it with the 1230v3 I had in this system before I got a 4790k. I use a CM 140xl now, with aftermarket fans. There's a lot of variables.
Big air is not without issues just like water cooling. *Shrug*
For me, keeping it cool was more important than the possibility of a leaky AIO. I don't move my system, so the weight and danger of damaging the mobo, wasn't relevant in regards to big air systems.
To answer your first question, "is it good?", the answer is yes, with caveats.