Short answer
Execution assumptions distort backtests whenever the simulated trade path is cleaner than the trade path a real operator could actually achieve. The classic shortcuts are zero slippage, perfect fills at the close or midpoint, no liquidity constraint, and no delay between the signal and the trade.
Those shortcuts do not damage every strategy equally. The more often a strategy trades, the smaller the expected edge per trade, or the thinner the market, the easier it is for a pretty historical curve to be mostly borrowed from unrealistic execution.