Also, whilst genuinely doing great as a dad, it is just apparent to me that he is not wired the same way as me/(dare I say women?!) to cope with things when the going gets tough. My daughter is lovely but very highly strung! Of course I’m hoping he’ll rise to it, I just know it won’t be easy for him and worry about how he is going to cope with such long hours alone as a parent without a car.
You asked for other people's experience. Well mine is that the above is where you will go wrong. DH does not parent like I do. As a SAHD, his responses and actions were different to mine. I had to teach myself that unless he was harming the DC, I had to step back. That HE was the responsible adult involved and that therefore I didn't get a say.
Many years later, I can say that his approach has worked well. We, as a couple, have had some issues re food for the kids where working out what is me being paranoid and him genuinely not feeding them appropriately has been difficult. But overall, I can see huge benefits for the DC in having him as a SAHP.
For example, DH plays with them at a level I simply don't. He will spend hours playing, imaginary games, active stuff etc. Even the BEST SAHMs I know play less with their DC. He takes them to places with, for example, huge climbing frames then is up there with them helping and encouraging them even from very young. He's also 500 x more arts and crafty and over the years has helped them with all kinds of projects (I'm currently redeeming myself by getting DD a toucan box - that's the kind of art and craft I can get behind! 
)
Ditto, he talks to them constantly. Most women, myself included, probably think more about age appropriate stuff etc. But when I look at how DH has spent the last few years talking to our DC, I think there's a very useful lesson there for the rest of us. He talks to them as children, but I think he gives them more credit than I expect.
DH is quite happy to let DD wear dresses and be pretty etc, but he actively encourages less gender stereotypical stuff all the time by design and by chance. He tells and shows her constantly that her body is hers to control and demonstrates that just because he's a man doesn't mean she needs to change her behaviour for him.
He didn't do a lot of the groups I would have taken the kids to, but he did actively search out sports and music groups that worked for him. And they always spent a LOT of time in the park and playground - time that if I'd been with the kids would have been spent with other mums etc. Instead, they would spend 2 hours playing football together.
There are things I would have done better - FOOD being the big one. But also more routine, consistency etc. I'd probably have encouraged more reading and formal activities. I absolutely would have done more socialising which, while meaning less time with me, would have meant more time with other children. But on balance, I think DH as the primary parent worked out better for them.