Saint's Row 2:
When Carlos gets chained to a truck and driven through town having the road and the rocks tearing him apart. It was sad because they were one of my favorite characters in the game. But at least he comes back as a zombie if you call "Eye for an eye."