On general principle, no. It's a cheap way to end ANYTHING, be it a game, book, movie or a series. I can't think of a single cliffhanger ending that was actually beneficial and the only reason why they exist is to set people up for a sequel. It is further criminal when that sequel doesn't get made, in which case you simply have one unfinished game/book/movie/series.
That being said, I tolerate cliffhangers when I can move on to the next part straigh away. Watching old series that end their seasons with cliffhangers isn't a problem if I can just move on to the next season. Same with books and games.
PixieFace said:
By virtue, a story should be neat and self-contained. The first Bioshock and Dragon Age: Origins were good examples of this. For me, at least, they left me feeling satisfied and not cheated out of an ending that I felt I quite frankly deserved after dumping so many hours into it.
That's not a cliffhanger, that's just leaving room for a sequel, with some foreshadowing thrown in for good measure. Dragon Age: Origins had a fairly well wrapped up storyline, with the big bad dead, the crisis averted and the kingdom saved.
A cliffhanger would have been if after the fight with the Archdemon, you got a cutscene of him beating the crap out of you, then closing in on your barely-conscious body, the image cutting out just as he lifts his claw to deliver the deathblow.