I think the movie "Titanic" is a pretty good example!

I want to add though, that the endings of novels, or movies can have both tragedy and happiness. A tragedy may occur, which is saddening and heartbreaking, yet something really great may happen as well, which is a neat twist to an ending in my opinion. The titanic, in a way, sort of qualifies as an example of this as well. Just my 2 cents.