Well, I will say Fable 2, since that was a pretty bad fight with the person who had tried to kill you on multiple occasions and killed your sister.
I am kind of mixed on my opinion of Borderlands possibly because the ending seems to go like this:
[spoiler/]You defeat the thing inside the vault only to learn there was never treasure inside the vault, the only thing inside it was some alien monster that other aliens tried to seal away inside it, and the thing helping you throughout the game was a weapon company's satellite that wanted it dead since someone was bound to release the thing.[/spoiler]
I am not 100% sure, but that is about what I got out of that ending. I guess it isn't that bad of an ending in itself, I am just mad that the final boss itself drops piss poor weapons most of the time... and that you can only fight him once per play through.
KOTOR 2 is one that keeps popping up, and I guess I agree. It took my till when I started writing the last sentence to remember the final fight, and that wasn't that great.
I will have to disagree with a lot of people's comments on Fallout 3. I mean, if you decide to be evil, I guess it is kind of lame, but I rather liked the ending where [spoiler/]you sacrifice yourself to finish the work your father started to save the world's water supply.[/spoiler] Granted, the DLC does kind of make me disappointed to learn that only a small basin around the memorial was actually cleansed, but that's not important. I will admit, it sucks not being able to travel around anymore, but that is more of a consequence of the ending rather than the story of the ending itself.