Greater Manchester mayor has earned public respect by going from insider to outsider, but economic doubts could undermine his bid for Downing Street