Ok Blue's *click* and have some physical feedback. Browns do NOT click but have physical feedback. Blacks are stiff with no tactility at all, reds are less stiff with no tactility (this is linear). Then there's also clears which are stiff like blacks, tactile bump that's harder than browns, and no click (also very few boards available).
Since you're playing sc2 and given your current opinion about tactility I'm betting everyone will be suggesting reds. I still say browns tho
With or without foam pads or o-rings or whatever the keyboard will still make noise. If you have silent switches (brown, clear, black, red) then the noise will come from the keycap bottoming out and topping out. You can apparently learn not to bottom out (I will never bother). As for topping out... nobody really has an answer as far as I've seen.