Here's a more recent one: Warhammer 40k: Dawn of War. It's been a while since I played, but if i remember correctly you end up beating the big bad demon, and it seems like the story might go on...then credits.
I never played the expansion, so maybe they ended the story.