It will come clear sooner than later that making loud noises will attract less than desirable attention. You should only go loud when it is absolutely necessary and you have no other option (or if you are doing some weird challenge). In most cases, the progression of the game will flow smoother if you simply opt for taking the quieter option in most situations.