Ironically, I am in process of this right now. No need to get deep into the details, but back in 2018, due to life changing events, I was not going to be able to work full-time at the location, so I told my boss and said I'd give him up to 6 weeks of continued work to help train other people. He said he'd think about it over the weekend. On Monday, he told me his plan which was that I go full remote and continue working on a reduced hour basis for a reduced salary. He said we'd try it for 3 months and if it worked, we'd keep going, if not, we'd both know we each did the best we could to accommodate my needs as well as providing the company the services they needed. It worked with zero issues.
Fast forward to the dreaded C19 world and everything changed. All of the sudden, everyone thought remote work was the way and many companies adopted it, but didn't do it methodically and so after doing it for a while, remote work went out of fashion and now the CEO's have to bang their fist on the table and say 'YOU MUST REPORT BACK TO THE OFFICE!!!', which in my case wasn't part of the job we had agreed to, but my manager's hand was forced.
So, I'm working on a calendar of how many days I'm willing to do a mix of remote and in-office work for the next 6-10 weeks to help document and train the necessary people. We both are honestly a bit heartbroken, as it is the general media/news that drove our CEO to make a unilateral requirement and that just won't work for me, as I was remote before any of this started. They're losing a 23 year worker. I'm ok with it, though, as the company has changed so much in the last 23 years that I wouldn't even apply for the job that I do today.
So, yes, it CAN work. I bet its a 1:10 or less and 100% depends on the relationship between you, your manager and any outside influences (like HR or CEO mandate etc.). If you do try it, be prepared to be walked out of the building, just in case.
Good luck choosing your path.