Nick Foster explores the various ways we think about the future, from thrilled anticipation through to panicked doom-mongering