My father lasted a year in retirement, after which he got so bored he went back to his last job as a "consultant" to his successor, effectively continuing what he had been doing in the previous ten or so years, except only visiting the office when he felt like it.
I don't recall him ever enjoying this job at all, but it seems sitting around with a sole purpose of waiting to die is even less fun