I hope (since they confirmed we aren't going to see it in DA:I) that we do see Kirkwall again in some future Dragon Age game. Mostly because I want to see how they recreate it with their better engine. Part of me feels like the locations in DA:O and DA2 were limited by their engine, and I feel like the Frostbite engine would make it feel more like how they envision it.
Like, looking at the Kirkwall map makes Hightown feel like it's supposed to actually be higher up on the cliff than everything else? But you really don't get any sense of that in DA2.