I don't think this is the one you're looking for, but your request reminded me of John's Prine's song "In Spite of Ourselves": look for lyrics halfway down this thread.