I have also had this conversation with DH though he does to some extent work on projects that are partly of his own choosing. "Just say you won't do it"...
Part of my counselling for depression has included being told multiple times by the counsellor "you need to lower your expectations" and yes this includes jobs that may never get done. I had a big meeting I was hoping to plan for this month or next but it isn't happening.
But then in the summer I had an invitation to submit for a special issue for something relating to some data that we collected TEN years ago (actually possibly more) and never published, the second phase of a study that was published in 2010. I had despaired over ever getting those data out there but what do you know, it did happen (well, waiting on reviews - this is the paper with the weird pre-edits that I declined to accept).
So maybe things just aren't happening NOW.
I need to make a decision today about the other paper that I am fed up with because of the THREE (or is it four now) R&R. I got a reminder that the revision is due and I am pretty sure I'm going to write back and basically say:
I've had 3 R&R and I have no guarantee that it won't be rejected or come back with another R&R as the journal doesn't seem to have moved its position in the last X years (OK there was at least one mat leave in there).
Although you say these are the same reviewers, at least one of them is asking for new things now (like tables) that could have easily been asked for in the first place.
My feeling is that editors should be indicating to reviewers that the FIRST review is the place for asking for that kind of thing and/or triaging the requests, not complaining (as they did) that I haven't answered all the reviewers' comments without indicating which ones were missed. [not sure about saying that bit as I may not want to shoot myself in the foot with the editor]
There are also contradictory requests in the different reviews - not enough background followed by "introduction too detailed".
So I'm going to take my ball home. (I should really have taken it home some months ago but have been busy with other things to be honest).