I've never seen this. I've seen variation in character morality make games much more interesting. I've seen non-alignment mechanics to that effect drive games in interesting directions. Alignment? That I've never seen help. Even the example in the first post could easily have happened without alignment ever being involved.