The ending for The Darkness is one of my favorites. The sequel's ending was pretty fantastic as well thanks to the brilliant way they linked the original game's story to that of the comics.
Fully agree with this article, which was a fun read by the way. Mass Effect kicked off to a promising start with the first game, but it has long reached the point where Bioware expects me to dish out hundreds of dollars for a story that never did reach its potential.
Paulie Franchetti from "The Darkness" is easily one of my favorite villains, even though he isn't given too much screentime. His actions and dialogue when he is on screen are so utterly despicable though, and never have I wanted to kill a villain in a game so badly. The Darkness itself is also an interesting villain because it grants Jackie tremendous power, but it also works against all of his motives, other than revenge.
_Doomsayer_'s comments