It might not be exactly what you're looking for, and it's no where as good a movie as Chinatown, but "Beneath the Planet of the Apes" (https://www.imdb.com/title/tt0065462) definitely ends on a very "down" note. I saw it for the first time a few weeks ago and was kind of blown away by the ending.