Twenty years on, head music editor Joe Casson revisits the Glaswegian indie darlings’ high watermark, a singular work of delicate loneliness and wry observation that demands your devotion