Sing a Sad Song
Personally, I love the gut-wrenching type. I love it when I invest a lot of emotional capital into a character who fails, actually fails. It doesn't happen often in literature. Ken Bruen's Jack Taylor comes to mind.
Don't get me wrong. A happy end can be a good thing too. Hollywood loves that end, no? But always?
Also, don't get me wrong, I've written novels that end Hollywood style. But when my heroes fall, they fall hard.
This type of story has its own emotional life. Why is it that people liked being scared, but don't like being saddened?
Or am I mistaken?