When Rishi Sunak cancelled HS2 at Conservative Conference, he announced the money would instead go on a wave of transport projects across the North.