Tight Fine-Grained Bounds for Direct Access on Join Queries