OP: there will be some commonalities but everyone's experiences will be different because there are so many different types of neurodiversity, and even the same type e.g. autism will impact different people in very different ways, depending on their particular sensory issues, etc. And because all ND people have different personalities as well as their differences, just like NT people do!
But FWIW, I have an autistic father and an NT mother. He has been a far, far better parent than her. Sure, he has his problems: he did not cope well with the noise of young children, and he's not great at emotional support. But it has always been clear that he loved us and wanted the best for us. Our main problems as children resulted from our hyper-critical and abusive NT mother trying to force us to be how she imagined we should be, punishing us for ND behaviour, lacking any empathy whatsoever and attempting to bully our autism out of us. And from NT step parents on both sides who again showed no acceptance of us, and insisted their partners prioritised their wants over our needs. I am resolved that my children will never, even be subjected to a step parent.
In terms of my own experience, I am autistic and have ADHD. I have two children, now 5 and 6, both autistic. One I think also has ADHD. They are absolutely amazing people and I would not change them at all. But they do have additional needs that makes parenting harder work (e.g. a lot of anxiety, extra appointments and needing support/ adjustments at school, sleep issues, meltdowns from overwhelm, sensory issues). And also more expensive: they cannot manage group childcare like wrap around care or holiday clubs so - as a lone parent with a demanding full time job - I have to spend a large amount of money on nannies.
I am a far better parent to my children because I am ND myself so I understand them and what will help them. I can give them the tools they need. Unlike my parents I fight for the support they need. When they are overwhelmed I understand it and can teach them how to regulate and recover. Some aspects of it are harder for me than they would be for an average NT parent, like noise and constant demands and lack of time to myself, although this would have been much more manageable if I was not a lone parent. It is also difficult because they are different and have different needs that sometimes conflict (although that can also be the case with NT kids). And that I have less time for each individually but again easier if there are two parents to split caring and working between them. However, they gain a great deal from having a sibling and from being so close in age which I believe outweighs this.
Keep in mind that you are quite likely to have ND children if you are ND and it is unpredictable how that will manifest. But again, that can be said of any child! It is always a gamble having a baby, for anybody. You don't know what their personality will be or health or needs. But given that you are more likely to have ND kids if ND yourself I would certainly ensure you are in a good financial position before having a baby. More than most children, ND children need stability and do not adapt well to change, in general. And the provision of support is so woeful that it makes parents' jobs much harder than they should be.
I recommend ensuring you have private healthcare in place that will cover the whole family so that you can access diagnosis privately not wait for years. Money put aside to fund OT and SALT etc privately if needed. For specialist childcare if they cannot cope with group settings. And ideally also for private school in case that is needed particularly for secondary stage because class sizes are too large and trying to get the state education system to meet the needs of ND children is pretty much impossible, particularly academic ones.