Who are some authors that sound like real, doubt-ridden, awkward, fallible humans?

Looking for books where the perspective is a realistic person, not a "writer" - self doubt, awkwardness, etc.

I sort of feel like in most books there is a pissing contest to be genius. The prose is filled with extravagant vocabulary, beautiful character observation, or momentous historical context. I feel like most books are the writer trying to sell some version of themselves in their idealized form.

It's true there are books where the narrator is unlikeable, imperfect, etc. but I want one where it's more like how we actually think, eg. "Am I remembering this conversation or was that a dream?", "Oh God does the cashier hate me, why do they hate me?", "Damn that person is hot and I'll never have a chance with them, I'm a loser", struggling to keep apartment clean, dealing with guilt and shame, being fallible, not being some genius with a godlike literary repertoire, conversations where there is miscommunication, misunderstanding, awkward fumbling, etc.

Maybe I just have low self esteem or am not very bright but I'd like to read a literary book where the author doesn't think they have all the answers, and the narrator feels like a real doubt-ridden and self-conscious human being.