Ewan MacColl did some good ones:

The First Time Ever I Slapped Your Face

and after a drunking session he did a whole Radio Ballad called The Big Hughie

For Enron and World Com he wrote The Ballad of Non-Accounting.

For US Presidents there was Go Down You Interns, Go Down

and along those lines in an unpublished (Boo hoo) novel I wrote I had a rather disreputable character sing Luck be a lady tonight, Luck be a lady tonight, Luck if you ever were a lady to begin with be one I can sin with tonight

Hamish Henderson was touched with that universal male wish when he wrote his great son Willie Mor.