If I feel fannish about a show, I definitely prefer an ambiguous ending (= better fanfic material). Other than that, it always depends on the story that's being told. An ending that guts me can also be satisfying from a narrative standpoint (= it was always supposed to end like this and couldn't have ended differently).