The BBC Scotland political editor has made a career out of telling other people's stories - and says now it's time to tell his.