Using the H70 as an example isn't a very good example of an AIO cooler - those smaller units, especially the older ones don't perform nearly as well as the newer, larger ones. Compare a newer 280mm sized unit from say Swiftek, NZXT, or even Corsair to the D15, and you'll find that they perform largely the same - you can usually push a CPU a bit higher with the AIO cooler if you crank its settings, but not a whole lot. The smaller H70/80s will work, and allow modest o/c, but IMO if you're going that route you may as well have stuck to air cooling in the first place.
There is a huge difference between all in one h20 coolers and custom loops with their own separate res, pumps, and water blocks. The cost goes way up, as does the o/c potential, but it's still a pita, lots of fittings and piping to do, and with each one so increases the risk of a leak or failure IMO.
The shop I used told me that they've had very, very few AIO coolers fail and leak, but you can read on various forums that while uncommon, it still happens frequently enough. I look at like this - if you can afford a custom h20 loop, you can afford for it to leak and fail and replace things anyway, or if you're into high o/c, you should expect failures anyway, leaks or otherwise. The D14/D15 is probably a better/safer option for most typical pc gamers than an AIO, however the AIO now are pretty reliable, but I keep an eye on the one I have now a lot more than I look at the other noctua cooled systems.
There are a pile of articles/comparisons of the D15 vs higher end AIO -
http://www.relaxedtech.com/reviews/noctua/nh-d15-versus-closed-loop-liquid-coolers/3Most give the D15 either 3rd, 2nd, sometimes 1st place - considering it's air, and much cheaper...
My D15's are only a couple months old, but my D14 is 4 years old, and still has 2 years warranty left, that I'm pretty confident won't be needed.