I had this with my mum and my Aunt, both of whom I had next of kin for.
With mum, we managed to keep her at home with a (privately funded) live in carer and a care package from social services, after a hospital visit, coming in to help to hoist her twice a day.
Because she lost mobility, it seemed that she was going to have to have care visits every 2 hours to turn her and it was going to be outside the care package and prohibitively expensive, but we managed to buy a Toto matress which turns the patient by gently inflating and deflating every 2 hours. It paid for itself in 6 weeks, as it meant she did not need as many care visits particularly at nightime.
So it is possible to keep someone at home - and the live in carer was not much more expensive than the local good care homes.
With my Aunt, however, we had to give in, and let her go into a home, because of some additional care needs. It was just too tricky to manage from home. The care home wasn't dreadful.
Is Beaconsfield too far away for you? I knew someone in the Sunrise home there who was very happy, though that was a while ago, and it certainly isn't cheap.
Best of luck on this next stage in your journey. Maybe you could explore whether you can provide a carer at home, along with equipment provided by local authority (hospital bed, hoist, recliner chair, raised toilet seat etc. Some local authorities are much better than others. )