Edinburgh. Don't claim to be especially well-travelled but can't think of many other cities where exiting a main railway station - in this case Waverley - gives you such an immediately superb location.