Hi Perdita,
Yes, I took mum out of care and cared for her here, 24/7 by myself for the last 7 months of her life. I am so glad I did, and only wish i could of done it sooner.
If it's something you feel that strongly about, then do it. I have absolutely no regrets.
Some folk may think you're mad to do it, but you know what ? Think like I did and do it for the right reasons, for me, it was about giving my mum the best time I could, for the time that she had left. Everyone's situation is different, I KNEW mum wasn't going to go on for much longer, and wanted to give her the dignity and love, care and attention she deserved, right up until the end. She had the most peaceful passing, without intervention, pain or suffering, it was very calm and almost serene. She would not of got that in the care home where she was.
You have to look at the bigger picture and try to look at all eventualities, I have 15 years of Dementia care behind me, so I knew what i was in for. That said, you don't have to have experience to be able to look after and care for someone. You say you have a lot of experience too, so I'm sure you are well clued up, it is different caring at home though as opposed to working in that field, as long as you can walk away from it now and again, have a bit of 'you' time, then fab.
There are good support networks out there, just make sure you have all bases covered.
Good luck and hope you make the right decision for your mum and for YOU