I’ve been a scifi and fantasy nerd for my whole life but Dostoevsky’s and Mika Waltari’s books have been more influential in understanding humans, their motivations and emotions than most of the fiction. Wish I could find more of something similar.
I would recommend short stories by Anton Chekhov, any "Selected Stories" collection is fine. His characters are just normal people from >100 years ago but they feel very real and relatable. He makes you feel as if you're inside their head, the topics are generally very tragic though and it can get a bit depressing.