Tight last-iterate convergence rates for no-regret learning in multi-player games