These aren't the ten most emotion-inducing books I've ever read, just the most notable examples that came to mind. I'm sure there are many more which have stirred me. Tears aren't always borne of sadness, also.
...well, things don't end well.
2. Flowers for Algernon, Daniel Keyes
...and then the effect diminishes and reverses itself, and Charlie is left staring at his old journals, not even able to read what he once wrote.
Her mom...doesn't make it. But Sunny does rally, and reunites with her best friend Dawn even though Sunny's behavior has driven them apart.
Guess how he dies.
6. Harry Potter and the Goblet of Fire/Half-Blood Prince/Deathly Hallows.
That's tear-invoking enough, but the end of the book is positively cathartic. I enjoyed it too much to spoil it, even though I doubt most people reading this read Trek literature, but...horror turns to ectasy. And it's not just, "Oh, yay, the end is averted" ectasy, either. It's...jubilation. Redemption.
And it gets better.
I don't think I cried, but I got teary-eyed. In case that's not enough for you, here's a bonus.