Decision about caring for bedridden parent at home or in skilled nursing facility. Any feedback?

I am new to this group and looking for resources as I am now faced with a decision about whether to move my mother into my home to care for her--which seems overwhelming, or to leave her in a skill nursing facility which she says she hates and would rather die than stay at.

My mother has declining mobility due to a very SLOW progressing cancer, and she has remained on hospice in her own apartment far longer than anyone thought possible. But after increased pain and a recent fall she can no longer walk or transfer herself, which means she can't use the toilet and now needs 24 hour care. She's been in skilled nursing less than a week and is currently on a catheter and using a bedpan. She also has a bedsore to contend with and has difficulty getting comfortable in more than one position. On the positive side she is cognitively intact, retains some upper body strength to adjust her position, and she finds great delight in simple things that she can still do--crafts, writing stories, eating good food, having interesting conversations, playing with her grandkids, and watching movies. Personality-wise she and I have had a great relationship over the past few years, but that has not always been the case, and she can be pretty critical and demanding of others. I have worked hard to establish good boundaries with her and I don't want to lose that.

I provide all these details because I am trying to get my head around what it would actually be like to care for her at home. My husband and I had previously discussed that inability to toilet herself would be the red line after which skilled nursing was the only option, but she is so unhappy there that I find myself reconsidering. But I am struggling to envision what this would be like or how stressful it might actually be. I know there is no right answer (it really feels like two very bad options), and no one can tell me what I should do, but I am interested in hearing from others who have been in this situation. What has it been like to care for a bed-ridden parent? Would you do things differently if you had it to do over? Is it crazy to consider bringing her home?

The logistics of bringing her home would be challenging with regard to space, and would certainly impact my husband and 2 kids. On the plus side, my mother could resume hospice care and a 40 hour per week aid who would handle bathing and other daytime activities while we are work. My girls love her and I imagine sharing meals and spending quality time with her in a loving environment surrounded by the people and things she cares about. But then I think about how much I hate changing the cat's litter box, and I think I am deluding myself.

So, any feedback on the realities of this kind of care at home? I do not want to bring her home only to turn around a week later to take her back to the facility once I realize how hard it really is.