I can think of one game that has a downer ending: Yume Nikki. Then again, it's a freeware game, so making a profit off of it obviously wasn't an issue. Oh, and then there's Metal Gear Solid 3. My god, MGS3.
Really, you mostly see downer endings alongside bittersweet or even happy ones; being...