100 years of General Relativity: On the foundations of spacetime theories