Well, thanks for ruining Miss Saigon for me, brdwaybabie.

.
What about Ragtime when Coalhouse gets shot? That was devastating it seemed to me.
Godspell is pretty sad as well. I was in that show, and I cried every night; the end is pretty tear-jerking, when the disciples say goodbye, and he gets crusified.