Books about realistic characters with realistic flaws?

I've been combing through Goodreads and Google Searches for about an hour now. I've been trying to get back into reading, but no snippet I read sticks, and every bad review I read wards me away from the books I hunt down. Every search request in Google I make feels like I'm asking a Barista for a 14-step Caramel-Vanilla Frappu-Cappu-ccino, or whatever the fuck.

I love books with strong, diverse personalities. I love characters who are humanly flawed, who make selfish/bad decisions, who have something wrong with them, but aren't caricatures. I love when a personality trait goes too far– A hard worker turning into an obsessive perfectionist. Caution into paranoia. Lenience in a father that causes his family to degrade into helplessness. A friend too considerate for your emotions, they can't correct your mistakes. A character with a trait that's recognizable and understandable, and then they gradually begin to slip.

I like grit, and dirty realism. I don't want 'fantasy grit,' where it's too gross or unsophisticated or cynical to make any reasonable sense. I want to read about real people, their flaws and all. I don't want to read about a character. I dislike fantastical/dramatic plotlines if they don't seem to make any sense. I like sociology and psychology. I like critiques on society, from a nuanced multidimensional perspective. Ideally, multiple perspectives and experiences all within one book.

I don't mind nonfictional, or biographies. But I am typing this intending for fiction! The most important thing to me is emphasis on characters and their personalities and their mistakes.