If you can touch type well and don't bottom out on your keys, Red isn't that loud since it's not a clickey switch. Still will make more noise than membrane keys.
It is a matter of preferance, personally I prefir the Logitech G510s 's sound and feel to any mechanical keyboard that I have tried, but that is just me. I would go to best buy and try out the different keyboard that they have on disply and see what you like.