When the gallery opened in 2000, it transformed the artistic life of Britain – and the world. We look back at spiders, splinters, sexual dependency and sunsets.