From Confinement to Clustering: Decoding The Structural And Diffusive Signatures of Microscopic Frustration