What I originally wanted to know was if can anyone recommend specific video cards that will work quietly in a non-gaming setup? For instance I've read about 660 ti's, 670's, and 680's from many different manufacturers. I've read about the different AMD cards. I've even read about passive cards and passive cards that people have rigged up silent fans with. I've seen the list of GPU reviews posted on SPCR.
Well 660TI up are mostly for gaming setup, i woudlnt recommend for anyone not gaming or using heavy cuda core application. In either case as per your request, the MSI Twin Frozer and Asus Direct CUII seem good options for high end cards both in performance/noise. I just built a new setup with 3570k + 660ti twin frozer and only the initial startup is noisy, once bios/windows loads its wisper quiet, the built in vbios design makes the card be still at 40% at 75C... so even under load is not that noisy.... but i also tried to use msi afterburner to overide the fan spees, and at 50% speeds starts to become noticeable, past 60% is insane, past 70% its a jet engine, past that you will faint out of the sound waves... lol jk. But if i were buying for me, i would probably go with Asus Direct CUII cooler, SPCR already reviewed the GTX670 DirectCUII and came out good.
As Vicotnik posted, there are some passive cooling solutions out there, that still need case airflow to be able to cool themselves, in my case i straped a 120mm to a passive gts450 and works great..., again really depends on what you are looking, here some models for you to check,Sapphire Radeon Ultimate HD 7750 1GB DDR5 HDMI/DVI-I/DP PCI-Express Graphics Card 11202-03-40GHIS HD7750 Radeon Graphic Card H775P1GDASUS Graphics Cards HD7750-DCSL-1GD5
With that said.... i strongly recommend you dont get a dedicated gpu unless you have to, a gpu like DIRECTCUII or Twin Frozer will not exit the heat, but dump it inside the case, increaseing the case temp, which will mean other fans will have to spin up faster to to cool it, thats if you have your fans ramping, or higher temps if you have the fans steady at one speed. Intel HD4000 is more than capable for every day task for an usual computer user, it will be much more efficient in terms of cooling and electrical consumption. Haswell comes promising better iGPU performance, as steve pointed, it could be up to twice as fast, some early benches pointed around a GT640.... which is not bad for a intergarted gpu, it should even be capable run popular games like LOL/WOW.... faster decoding/encoding with more capble iGPU... etc. Overall Haswell looks like a very low gain on cpu power while almost doubling the GPU power.