No such sweet spot tbh. This is why I mix rep ranges. It again depends on the movement/your training plan, etc.

General rule of thumb is for large compound lifts, lower rep ranges are better and for pure isolation exercises, higher ones