Autonomous vehicles are increasingly seen as at the heart of a radically different future landscape for transport solutions in the world's major urban areas. But don't believe all the hype, says Dave Leggett