I think this is too personal to give a sweeping view.
I adored my DF - but in retrospect he swanned off to travel and have fun overseas (for several years) when things were very bad at home and Social Services/Child Psych was involved. As an adult I can see that was extremely shoddy parenting and neglectful, even though I know he loved me very much. He became very ill in his 60s and I cared for him until his death. Despite the fact he did abandon me when I needed him, I'm still so grateful I had the chance to care for him. Although he was a selfish man he did love me. And he made me feel loved, even if he still went off gallivanting at a time of crisis for me.
In contrast, my DM made things a misery when I was growing up and I left home at 17. She is a very difficult person with all kinds of emotional and psychological shortcomings. Over the years she has acted very badly in many ways and I have been SO close to going NC. My DB is NC with her.
And yet.....I'm now 45 and I think time and maturity has given me new perspectives. I actually think she's autistic but not diagnosed, and has no insight into how she is. The thing about my DM is that amongst some truly terrible things she has done, I think she means well. And I think her own actions have made her life a car-crash - and I have some empathy with her for that. She's never managed genuinely close, loving relationships with people - she's married (she divorced my DF when I was very young) but her marriage isn't close or loving. I feel sorry for her because she's missed out on so much by being the way she is.
And here's the weird thing. I'm about to buy a house with her - she's going to live in the annexe, and I'll have the main house. She's disabled so I'll be nearby if she needs anything. I work F/T and I've got two autistic DC who I home educate so I have my hands full - but I also want to make sure she's feeling reassured and safe in her twilight years. And actually, I'm now at a point where I'd be devastated to lose her. I've had some frank conversations with her about how difficult she is - and the problems her behaviours cause. I really can't emphasise enough she has been AWFUL in the past, I felt traumatised by her parenting for many, many years and my difficulties with anxiety and panic now are undoubtedly in part due to her. But weirdly - and I don't know how - I've reached some kind of peace with it all.
My DF died before any of us were diagnosed as autistic but he used to tell me to try and understand her. He was a fiery, tempestuous, chaotic individual who didn't suffer fools gladly - but somehow he saw past DM's difficult exterior and he always urged me to do the same. I never could before - and he died 8 years ago now - but I don't know.....something has changed. I feel OK about things. But as I say, that's such a personal decision there's no "right" answer - you have to do what feels right for you. Listen to your instincts.