When the pc is idle it's really quiet. I've got a ton of 120mm/140mm fans in there, all slowed right down with fan controllers.
The gpu's and the DVD drive are really noisy when they're in use..... but I don't tend to use the DVD a whole lot, and I play my games loud enough to drown out the sound of the GPU fans when they're on load.