The Cultural Foundation's three new exhibitions shine a light on past, present and future