You are looking for something that is different for everyone. A book has to be well-written, well enough that you can imagine yourself in a given situation. The author has to "click" with you - but here is where the problem inherent in your question pops up. Every author is different. Every reader is different in how they react to each author. A book that moves me to tears might have no effect on another person. What you requested is a subjective issue. A book with a high level of poignancy might be hard to find unless you already have a high degree of empathy.
The thing that brings tears to MY eyes with regularity is my annual federal tax return. (Fortunately, these days it is a quick read.) It might sound like I just gave you a dismissive example - but the point is that if you can't "connect" with the content of the story, it isn't going to move you to tears, and that connection is the most important aspect of your question.