I have a 4790k and an h100i on an ASRock z97 Extreme4 mobo. I run a 24/7 OC of 4.7 GHz @ 1.23 V on the Vcore; however, the temps reached up into the high 90s when running about 5 minutes Prime95 26.6. I can run a stable 4.8 GHz @ 1.32 V, but temps hit the 100 C mark within a minute using the same program. I don't put a lot of stock in Prime (several runs of RealBench and Cinebench, coupled with some extended gaming, is enough for me), but even RealBench was getting upward of 90 C. Gaming doesn't get over 65 C, but the insane temps still bugged me due to the low voltage. Soooo, I decided to delid it using the vice method. The process was a little scary (I booted and only got single channel RAM access; after removing the chip and re-cleaning, it worked fine), but now I top out at 81 C after 30 minutes of Prime and my temps are even across all four cores. I used Antec Diamond 7 on the die until my Liquid Ultra arrives later this week. No OC tweaking since undergoing the delid process, but I will tinker w/ it very soon. As for the noise, that all depends on how many fans you have on the radiator, the brand of the fans, and your fan speed profile. I have two Noctua F14 fans running as exhaust on my radiator and they're pretty quiet at high speeds.
tl;dr: The h100i is going to do just about as good a job as any cooler possibly can on the 4790k, but Haswell's manufacturing process could still hold you back in the end. As long as you're okay w/ "gaming" stable, 4.6-4.8 GHz is a realistic expectation. Still, results can, and will, vary. If I can't get good temps above 4.7 GHz, I'll still be extremely happy with the performance I'm getting.