Been living and cycling in Glasgow for 3 years. Now returned to Leith as a much more experienced rider and alarmed/disappointed by much that I see. But also big hopes for whatever they're doing to Leith Walk at the moment: that 100m stretch of new road surface is very nice... if they just keep the cones up so there's no motorised traffic on it we'll be sorted.
Edit: You may see me riding between Leith Walk and Waverley of a morning or evening on a grey Ridgeback hybrid and helmet cam. Say hello!