Depends what you're doing. I've never noticed any of the current iMacs getting too loud though, even under intensive GPU apps. MBP, on the other hand - it's that much smaller so needs to ramp its fans up a lot when working hard. It's hardly massively loud though.
Anyone know how loud the current crop of MBPs and imacs get? Or are they passive cooled only?