I have also heard it used in a far less negative sense: for example a grandfather might say that he will not, under any circumstances, buy candy for his granddaughter, but "one smile from that cherubic face, and I am undone."

Alex