Iain M. Banks. Many of his endings are tragic, or at least bittersweet, and have some sort of a twist in them, so slightly YMMV. But they do always bring closure, and "then almost everyone dies" is an entirely reasonable ending if the characters were on a suicide mission all along.