I like hapless and terminally unlucky characters. It's fun coming up with the fiction for a failed roll being crazy bad luck, and it turns failure from something that feels bad into something fun and expressive of your character.
I like any archetype that has some sort of quality to turn the inevitable failed roll into a character moment, really. I think it's a side of character building that alot of systems skip- especially wargame type systems like DnD- which naturally leads to power gaming and meta gaming, since a failure feels like a wasted turn otherwise.
The biggest thing I dislike in any game is when you try to do something and effectively nothing happens.