My eyes glaze over when fantasy novel summaries start talking about usurper kings and world-dominating overlords and epic wars between good and evil. I'm in the mood for something that puts me in an imaginary world and just lets me kind of experience the small-scale but meaningful stories of well-realized individual characters.
The most obvious example that comes to mind, of what I've read, is the Discworld series. I've only read a couple of them (Small Gods and Men At Arms), but I enjoyed them a lot. If anyone thinks there's another Discworld book I should definitely read next, I wouldn't mind hearing it, but I'm looking to expand my horizons a bit.
The only other example I can think of is the Imaginary Veterinary series. They're children's books, but I'm not in a particularly picky mood, and the "protagonists are apprentices at a veterinary for mythical creatures" premise is refreshing enough that I had a fun time with them.
Well, I haven't read too many fantasy books, but I did like this one
https://www.lovelybooks.de/autor/Michael-J.-Sullivan/Theft-Of-Swords-The-Riyria-Revelations-972256589-w/
It's a rather straight-forward heist story where the main appeal is the excellent pacing and how easy it is to read. I thought it was a really well-done action/fantasy.
Apparently there's a whole sub-genre of fantasy/heist stories.
https://www.barnesandnoble.com/blog/sci-fi-fantasy/12-fantasy-heist-novels/
EDIT: Oh, and I guess the First Law trilogy by Joe Abercrombie also qualifies. It's kinda grimdark in the ASOIAF vein, and it's somewhere between small and grand scale, but it's also definitely one of the better fantasy stories I've read.