It should be (almost) unnoticable when using the PC in office mode, that's the whole point for me. So it should be a good compromise between noise and graphic power...
There are some cards with custom coolers that are quite powerful and silent. Check the Asus Direct CU II line (AMD 280X / nVidia 770), among others.
Passively cooled GPUs have a hard time dealing with demanding games.