Once again, inspired by Baldur's Gate 3.
After over 200 hours noodling on other playthroughs (got to see how Gale does it, nearly had a Dark Urge moment - but that's for a different discussion) I've finally reached the city proper. No, the nice auntie was not able to homeopath me back to health but I have had some refreshingly direct discussions with my Githyanki physician. I'm sure the psychological trauma will wear off. Eventually.
Now I get to see how the dev team handled city building. It's interesting, certainly. You are kinda left with the impression that the city exists for player characters to experience, but I suppose the same argument could be made for, say, New York. Every tourist thinks that New York was built for them alone because they only ever see those bits of New York that were built with tourists in mind. Students at CUNY probably feel the same way, at least in their first year, before they start stepping out of their comfort zone. When in a curated environment everything seems built for you, until you start looking for the things that aren't.
When designing an urban environment of the fictional variety it's usually a good idea to look at how it's been done before and by that I do not mean 'how did Tolkein do it?' No, I mean how did we do it, and the answer can be found in the oddest of places.
It depends on what kind of fiction you intend to write. For Keepers and Trail GMs, I always recommend Only Yesterday: An Informal History of the 1920s by Frederick Lewis Allen, followed by Since Yesterday: The 1930s in America, and then, if you're really ambitious, Big Change: America transforms itself, 1900-1950. There is no better coverage of the period. If you really want to go gonzo nuts then Middletown: A Study in American Culture by Robert Staughton Lynd and Helen Merrell Lynd is worth your time but it's a bit of a brain-breaker.
The point being that you do not know what tools you have to play with until you look into the box and see those tools for what they are. There are always ideas you haven't thought of. Concepts that never occurred to you, worries that you never knew anyone had, and you won't have the slightest idea until you go looking for them. Or to put it another way, until you start looking for the things that aren't built for you, you don't know what's really out there.
Let's say this is a fantasy setting. What resources exist?
Well, Diana Wynne Jones' Tough Guide to Fantasyland is a damn good start. If you, as an author, can read that without blushing and confessing, perhaps through gritted teeth, that you too have been to Fantasyland, then you're a better author than I.
However, if you're looking for a fantasy city (or possibly a fantasy village) then I highly recommend Joseph & Frances Gies' Life In A Medieval City, or Life In A Medieval Village. Perhaps followed by a dessert course of Myddle by Richard Gough, if you enjoy period pieces. Life in a burgher's household, big business, small business, the church, the condition of the streets, books and authors, disasters, fairs - it's all here. A moveable feast of material.
What kind of feast?
Well, taking a look at Life In A Medieval Village: 'One holiday, Wake Day, the feast of the local parish saint, varied from place to place. Probably in the 13th century, as later, the villages kept vigil all night, in the morning heard Mass in honor of their patron saint, then spent the day in sports. Often the churchyard was turned into a sports arena, a usage deplored by the clergy ...'[p102]
Let's say this is Ravenloft. In that setting there is the Church of Ezra. 'Pious souls in various domains pray to Ezra, an aloof god who embodies the Mists ... With no domain-spanning organization, the church serves largely as a formalization of local superstitions ...'
It's reasonable to think that, in at least some of the Ravenloft realms, Ezra may have local saint figures or provincial heroes who fill the same role. Or that Ezra has different aspects, just as in, say, Greek mythology where Zeus has many aspects: Zeus Agoreus, Zeus Xenus, and so on.
Let's say that this is Mordent. Ravenloft's equivalent of Hammer Horror Cornwall/Kent/Sussex. Mist-shrouded coastline with a ghostly secret.