There is a breakdown of all of the genuine Cherry MX switches in this wiki article.
The MX Blue switches are very common and make the distinct clicking noise as you type. It is up to personal opinion whether the noise is too loud; I would be annoyed if the person beside me used a keyboard with MX Blue switches all day.
The MX White and MX Green are variations of the MX Blue that require more force. These are probably harder to find in stock at a local retailer because they don't seem to be as popular.
If you want the same tactile feedback as MX Blue without the clicking noise you should go for MX Brown.
Likewise for MX Blue, there are also Clear and Gray switches which require more force.
There are also several other brands of mechanical switches which could offer something in the sweet spot between MX Blue and MX Brown, but your question asks for Cherry MX switches only.