No, it's not what you think! I mean intimate in the sense of a small story, with either very few characters or a sensitive subject. Check out these three novels:
The Three of Us - a wife's husband and best friend hate each other, and we see each of their points of view
When We Were Worthy - in the wake of great tragedy, a small town grieves and comes together
Alias Madame Doubtfire - the novel behind the film Mrs. Doubtfire, showing the damage divorce does to children