I can see it being really annoying being in a room full of people typing on mechanical switch keyboards. I work in an office alone and am alone in my room at home so it hasn't been a concern for me.
We had a thread in our peripherals subforum about it but I can't locate it at the moment.
For a quick yet indepth intro I like the overclocker's guide: 
http://www.overclock.net/t/491752/mechanical-keyboard-guide If you do decide to buy a keyboard, geekhack is a good place to look. It's like Head-Fi, a lot of information, maybe even way tooo much. Wade carefully.
I have been happy with my upgrade to mechanical keyboards. I was using the microsoft natural 4000 multimedia keyboard which I loved. But I was replacing it ever 12-18months cause the keys would get all mushy and not type as well and it would be a pain. I decided to invest in a mechanical keyboard instead to get a more consistent typing experience since I write documentation for a living. I miss the ergonomic shape, but the typing experience is better overall. 
I have two keyboards. A Filco with brown switches, and a Rosewill with blue switches. I like them both and could probably be happy with either one. I prefer gaming with the brown and typing with the blue. 
The blues are significantly louder than the browns, If noise is a concern the browns might be a better choice. The browns are still louder than my MS Natural Multimedia (or any rubber dome keyboard) though. you can watch youtube videos to get an idea of what kind of noise you might expect.  People also have bought and placed rubber o-rings on the switches/keys of the keyboards to reduce noise which works for the browns, the blues actually have something in them that click so it doesn't reduce that noise.
For my main concern (durability/quality over time) my brown types pretty much like the day I bought it 8 months ago. My blues are the same way though I've only had it for maybe a month.
If you're typing a lot at all I'd go for either the brown or the blue switches. I didn't like the way the blacks felt at all.
If you want to try it out go to a store and feel them: you're best bets in store would probably be:
Razer Blackwidow (uses cherry blues)
Steel Series 6gv2 (uses cherry black switches)