We got a dog due to my DD1 having Aspergers. She has a natural affinity with animals & I thought learning how to decode what a dog thinks from watching their body language & expressions would help her to learn how to decode humans!
We got a collie, partly because I grew up with a collie / whippet cross & partly because in our isolated rural location you don't get many other dogs :)
Kipper is amazing, so good with both my DDs. Sunday morning we had a half hour drive to a party, DDs (7&8) very excited. He spent the entire journey head between theirs, from the boot, having unicorn spells cast on him. He loved it :)
He also drives me mad, we have builders next door for a week, every time they drop a tile he barks.
DD1 can tell instantly if Kipper needs something (but is still hopeless with humans), but it has still really helped.
I was struggling with depression, parenting a child on the Autism spectrum is hard, but I didn't want tablets. Walking Kipper twice a day for an hour each time has been a godsend. I cannot stress how much it has helped.
Also I have found other dogwalkers to be very friendly, I have made more friends in the last 18 months walking the dog than I did when my DDs started school. Proper friends of all ages from all walks of life. It is surprising what you can discuss in a Force 8 gale & pouring rain :)
You are an experienced dog owner, you know what is required. It was the positive impact on my mental health that surprised me the most.
Go for it :)