Well you're on Tech Report, so you know we love mechanical switches
Personally, out of the Cherry lineup I would go with either Blues or Blacks. I love hearing the response from my keyboards with blue switches (I've got a BlackWidow and a Rosewill at work), and losing that makes the tactile bumps of brown or clear switches "meh." Actually, browns felt so light for me that they might as well have been linear, hence my recommendation of Black switches if you don't go with blues. Reds are linear, too, but I feel like I type pretty heavy, so I like having resistance.
Keep in mind that there are two sounds that come from mechanical switches like these. Blues have an audible click regardless, so you won't get that on Brown, Red, or Black switches. Most of the noise, however, actually comes from bottoming out the switch, which is basically like crashing the keycap into a big, plastic, resonating body. So if you want quiet, get something with some sound suppression under the caps, or plan on getting dampening rings from wasdkeyboards.com.