Too tight and trades fail. Too loose and you may accept a bad price. Read slippage and price impact.
Trading
What is slippage tolerance?
Short answer
The largest price difference you will accept between the quote and the fill. If the price moves further, the trade fails instead of filling.
Updated