I too wrote a reflective piece based on my past recently, and I was close to tears at one point while writing. Although others enjoyed the piece and feedback was very positive, I'm not aware of anyone feeling emotional over it.
As for other people's books, the only one that comes to mind is my recent read of Vonnegut's Sirens of Titan. It's quite possible that no-one else here who has read it found it particularly moving, but for me, the last page was unexpected and, I felt, quite sad, and sat at my desk in the office at work at the end of lunchbreak, I had to choke back tears to avoid making a fool of myself.
Both of these were quite recent, and may just be a result of a recent personal event that has left me slightly more emotional than usual. No doubt in a month or two, when things have returned to normal, I'll be 'hard as nails' and scoff at sad endings.
Omni