For me the most interesting case is HeidiSQL. I find it easily the most useful SQL GUI client, but it crashes pretty frequently, but not frequently enough for me to stop using it over the alternatives.
I often wondered how to strike the balance right on these things, since apparently all options can lead to success.