AIO is generally "recommended" but you don't need it, especially when sticking with ~4.7ghz six core. If you don't care about seeing really low numbers on your CPU temperature readings, it doesn't matter, you shouldn't get near your TJ Max during any real workload.
The NH-D15 is probably the best for air cooling, but it's large and not very pretty. Front fan may need to be moved up 2mm for RAM clearance (should be just enough for your case). Otherwise there's the NH-D15S, which just doesn't have the front fan (also a little cheaper) and performs almost exactly the same. Some also say these Noctua coolers have simpler installation than many other air coolers. With the i7 8700k at 4.7ghz I would be surprised if you got over 70C during load or reached 70C with Prime95 Blend or In-place Large FFT stress testing. You might fare better, but you might thermal throttle during Prime95 Small FFTs, but this kind of stress test doesn't represent real load performance.
I'll tell you that large heat sinks might be cumbersome to install with the Z370 Aorus Gaming 7 (at least something like the Cooler Master MA620P) because the VRM "heat sinks" are pretty obtrusive and
can make getting angles to torque things hard ( This might not end up being a problem if you go NH-D15, though). It will probably be considerably easier (or more plausible) to install the heat sink before you install the Aorus G7 into the case,
if you weren't planning on that already.
Just make sure when deciding on an air cooler that you check for RAM clearance and what height your case supports. You can of course get an AIO, simple installation, mostly minor (but realistic) risk involved [you can read some forum posts about accidents], but if you're not comfortable there's no need to go liquid get perfectly safe temps with those clocks, even with the 8700k.