Kirkwall was a good attempt. It wasn't small and titchy, it gave you a nice sense for a semi-grand fantasy city. Plus the whole concept of seeing it change over time depending on your decisions was really nice to talk about.
Unfortunately, it just wasn't executed that well at the end of the day and some of the points that had been hyped on it before hand didn't seem to actually occur.